Grades for Khoi Ti X 8.2 Microsoft Exc X MindTap - Cengas X Excel Online Stud X Excel Online Stud X Excel Online Stud X MindTap - Cenga X Course Hero X + - C https:/g.cengage.com/staticb/ui/evo/index.html?deploymentld=5935112189509097482354739820&elSBN=9780357110614&snapshotld=3080060&i... ( * Khoi v KL CENGAGE | MINDTAP Q Search this course ? My Home 8.2 Microsoft Excel: Structured Activity #4 X Question 1 Courses 0/10 Marvel Studio's motion picture Guardians of the Galaxy opened over the first two days of the 2014 Labor Day weekend to a record-breaking $94.3 million Catalog and Study Tools Submit in ticket sales revenue in North America. The ticket sales revenue in dollars for a sample of 30 theaters are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. A-7 Rental Options College Success Tips Open spreadsheet a. What is the 99% confidence interval estimate for the mean ticket sales revenue per theater (to the nearest dollar)? Career Success Tips ($ RECOMMENDED FOR YOU Interpret this result. Loan (i) We are 99% confident that the population mean lies inside the interval. 8 O (ii) We are 99% confident that the population mean lies in the middle of the interval. Current Account $ 2,217.90 (iii) We are 99% confident that the population mean lies outside the interval. Current Balance Mobile Payments $ 2.217.90 (iv) We are 100% confident that the population mean lies inside the interval. bongo (v) We are 99% confident of all observations are in this interval. Manage Student Loans Choose the correct option. ? Help b. Using the movie ticket price of $8.15 per ticket, what is the estimate of the mean number of customers per theater? Give Feedback customers A+ c. The movie was shown in 4050 theaters. Estimate the total number of customers who saw Guardians of the Galaxy and the total box office ticket sales for the weekend. customers $ million (to whole number) Back NextGrades for Khc X 8.2 Microsoft X MindTap - Cen X Excel Online S X Excel Online S X Excel Online S X Excel Online S x MindTap - Cer X Course Hero X + C @ about:blank Excel template 9 Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments 1 v Arial 10 B V M Av . .. Ev ab General $ v 00 . .. D2 V X V fx A B C D E F G H I J K L Revenue ($) Formula Used 32, 100 Sample Size #N/A W N 20,860 23,210 Point Estimate of Mean (to the whole number) #N/A 26,400 25,695 Standard Deviation (2 decimals) #N/A 20,615 22,630 Confidence Coefficient 0.90 19,800 10 18,690 Level of Significance #N/A 11 16,750 21,650 Margin of Error (to the whole number) #N/A 13 24,960 14 25,520 C.I. Lower Limit (to the whole number) #N/A 15 26,500 C.I. Upper Limit (to the whole number) #N/A 16 25, 170 17 21,270 Movie Ticket Price 8.15 18 33,920 19 13,660 Mean Number of Customers per Theater (to the whole number) #N/A 20 23, 770 21 22,450 Number of Theaters 4050 22 19,920 23 21,230 Total Number of Customers #N/A 24 23,920 25 25,520 Total Box Office Ticket Sales (to the whole million) #N/A 26 22, 150 27 23, 710 28 26,040 29 21,830 30 23,340 31 19,710 32 33 E Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +