Question: QUESTION N 15 MARKS Thirsty Thursdays is an upscale all inclusive party that takes place on a Thursday night. The promoter, a Utech graduate believes

 QUESTION N 15 MARKS "Thirsty Thursdays" is an upscale all inclusive
party that takes place on a Thursday night. The promoter, a Utech

QUESTION N 15 MARKS "Thirsty Thursdays" is an upscale all inclusive party that takes place on a Thursday night. The promoter, a Utech graduate believes that the reduction in the number of patrons is as a result of increase in ticket price. He has been tracking, analyzing data and developed a regression analysis in excel as seen in the printout below. SUMMARY OUTPUT Regression Statistics Multiple R 0.753937 R Square 0.568421 Adjusted R 0.514474 Standard E 651.0488 Observation 10 ANOVA S MS F Significance F Regression 1 4466084 4466084 10.53658 0.011771 Residual 8 3390916 423864.5 Total 9 7857000 Coefficientstandard Em t Stat P-value Lower 95% Upper 95%ower 95.09Upper 95.0% Intercept 6541.664 765.0242 8.550923 2.7E-05 4777.515 8305.813 4777.515 8305.813 X Variable -0.44872 0.138237 -3.24601 0.011771 -0.76749 . -0.12994 -0.76749 -0.12994 a) From the printout above develop the least squares estimated regression equation of the study to 2 decimal places 5 marks b) What is the value of the Product Moment Co-efficient of Correlation? What is the relationship between the variables? 3 marks c) Is the model a good predictor, why? marks d) If "Thirsty Thursdays" decide to sell entry tickets at a price of $8500, approximately how many patrons can they expect 3 marks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!