In 2018, 14.77 million people attended a Broadway show, paying an average of more than $120 per ticket. So what variables are related to the success of a particular Broadway season? Data from the Broadway League, Inc. (www.broadwayleague.com/research/statistics-broadway-nyc/) are used to estimate the following multiple linear regression model:
Grossi=β0+β1Attendancei+β2PlayingWeeksi+β3NewProductionsi+εi
for i=1,⋯,35 . The following data are gathered for each season from 1984 to 2018:
Excel was used to estimate this model and the output is provided below.
|
Regression Statistics |
|||||||
|
Multiple R |
0.922185639 |
||||||
|
R Square |
0.850426354 |
||||||
|
Adjusted R Square |
0.835951485 |
||||||
|
Standard Error |
183.1940204 |
||||||
|
Observations |
35 |
||||||
|
ANOVA |
|||||||
|
df |
SS |
MS |
F |
Significance F |
|||
|
Regression |
3 |
5915152.02 |
1971717 |
58.75192 |
6.84E-13 |
||
|
Residual |
31 |
1040361.523 |
33560.05 |
||||
|
Total |
34 |
6955513.543 |
|||||
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
|
|
Intercept |
-1345.794142 |
340.4476833 |
-3.95301 |
0.000416 |
-2040.14 |
-651.447 |
|
Attendance |
258.0733774 |
66.98749021 |
3.852561 |
0.000549 |
121.4515 |
394.6953 |
|
Playing weeks |
-0.831807119 |
0.639068006 |
-1.30159 |
0.202645 |
-2.13519 |
0.471581 |
|
New Productions |
12.64582072 |
7.912639627 |
1.59818 |
0.120147 |
-3.49211 |
28.78376 |
[JP1]Beginning with the 2009-10 season, "Gross" represents gross gross—which is the gross earnings before deductions. For prior seasons, “Gross” represents net gross earnings, which is the income after accounting for deductions incurred by the show.
[JP2]Note: before 2009 this is paid attendance, beginning in 2009 it is attendance
The percent of the variation in Gross earnings is explained by this regression model is R square value which is 0.850426354.
Thus, 85.04% of the variation in Gross earnings is explained by this regression model.
In 2018, 14.77 million people attended a Broadway show, paying an average of more than $120...
Problem 6 Simple Linear Regression To the Internal Revenue Service, the reasonableness of total itemized deductions depends on the taxpayer's adjusted gross income. Large deductions, which include charity and medical deductions, are more reasonable for taxpayers with large adjusted gross incomes. If a taxpayer claims larger than average itemized deductions for a given level of income, the chances of an IRS audit are increased. Data (in thousands of dollars) on adjusted gross income and the average or reasonable amount of...
please show all work and graphs
SUMMARY OUTPUT Regression Statistics 0.989894408 Multiple R R Square 0.97989094 0.946375839 Adjusted R Square Standard Error 0.093997207 Observations ANOVA F Significance F MS 5 1.291627011 0.258325402 29.23729686 0.009507436 Regression Residual Total 3 0.026506425 0.008835475 8 1.318133436 Coefficients Standard Error Stat 2.000000 1.000000 1.000000 0.199040522 12.23566447 0.001175553 1.801957267 3.068828814 0.116964675 7.144529794 0.005645963 0.46342381 1.207891408 0.221410557 -4.794091072 0.017265888 -1.766089586 -0.356835166 0.115122597 -2.041317871 0.133876794 -0.601373298 0.131369669 0.500000 0.130770483 -4.049701664 0.027116334 0.945751481 -0.113411402 Intercept GPA Fin Major Gender...
Study Prep, Chapter 13: Correlation, Simple Linear Regression, Multiple Regression MULTIPLE REGRESSION Major League Baseball Team (Team) recently hired Trixie, a third year student in the Fowler College of Business, for an internship position. After showing Trixie around the facilities, Team provided Trixie with an office, desk, computer, phone, and instructed her to "figure out what professional baseball teams need to do to get fans in the seats." Below is a regression model Trixie developed in trying to get a...
Please use Excel, and show all functions.
3. Answer the following question for where Y has been regressed on X1, X2, and X3. Use the linear regression output in the Excel file. Your answers should be rounded to 2 decimal places. a. What is the equation for the line of best fit or regression line? b. The proportion is for the amount of the variability of Y that is explained or accounted for by the model. C. The correlation between...
Hello I need help with questions 2 until 9 if possible. If you
can please show all work and answers clearly. Thanks for all the
help have this project that’s due tonight so I need help on
thanks.
27 27889.0526471 10.12 1.09 28 SUMMARY OUTPUT 29 30 Regression Statistics 1 Multiple F 0.986442 32 R Square 0.973068 33 Adjusted 0.967681 34 Standard I 32.55341 35 Observati 36 37 ANOVA 38 39 Regressio 40 Residual 41 Total 42 43 44 Intercept...
a) Write the linear model equation for the
regression line identified by this Regression Report.
b) Do all three advertising types (Television, Radio or Google)
have a positive impact on sales? Which has the greatest impact?
Explain your answer.
c) What is the confidence interval and p value for the
independent variable “Radio”? Does radio have a significant linear
relationship with Sales?
d) What is the net effect on Same-Week Sales of spending $1,000
in a week of television advertising?...