Note :I have the Answers however I need the details and
the steps to get that answer and not using excel all
manual

Show transcribed image text Movie Revenues 23. A financier whose specialty is investing in movie productions has observed that, in general, movies with "big-name" stars seem to generate more revenue than those movies whose stars are less well known. To examine his belief, he records the gross revenue and the payment (in $ millions) given to the two highest-paid performers in the movie for ten recently released movies 1 Movie Gross Revenue mil 48 65 Cost of Two Highest Paid Performers (Smil) 5.3 7.2 1.3 1.8 3.5 2.6 8.0 2.4 4.5 6.7 18 20 31 26 73 23 39 58 4 6 10 24. {Movie Revenues Narrative) Predict with 95% confidence the gross revenue of a movie whose top two stars earn $5.0 million ANS; 45.65 ± 4.916. Thus, LCL-40734 (in $1,000,000s), and UCL-50.566 (in $1,000,000s) 25, {Movie Revenues Narrative} Estimate with 95% confidence the average gross revenue of a movie whose top two stars earn $5.0 million ANS: 45.65 ± 1.54. Thus, LCL= 44.11 (in $1,000,000s), and UCL-47.19 (in $1,000,000s)
Movie Revenues 23. A financier whose specialty is investing in movie productions has observed that, in general, movies with "big-name" stars seem to generate more revenue than those movies whose stars are less well known. To examine his belief, he records the gross revenue and the payment (in $ millions) given to the two highest-paid performers in the movie for ten recently released movies 1 Movie Gross Revenue mil 48 65 Cost of Two Highest Paid Performers (Smil) 5.3 7.2 1.3 1.8 3.5 2.6 8.0 2.4 4.5 6.7 18 20 31 26 73 23 39 58 4 6 10 24. {Movie Revenues Narrative) Predict with 95% confidence the gross revenue of a movie whose top two stars earn $5.0 million ANS; 45.65 ± 4.916. Thus, LCL-40734 (in $1,000,000s), and UCL-50.566 (in $1,000,000s) 25, {Movie Revenues Narrative} Estimate with 95% confidence the average gross revenue of a movie whose top two stars earn $5.0 million ANS: 45.65 ± 1.54. Thus, LCL= 44.11 (in $1,000,000s), and UCL-47.19 (in $1,000,000s)





