X x Book.xIsx * 0 4 Update C ashedu-my.sharepoint.com/:x:/r/personal/cecilia_conrad_student_uagc_edu/_layouts/15/doc2.aspx?sourcedoc=%7B45380632-2EAC-4807-B37D-6D5F878... LE CC Excel Book - Saved Search (Alt + Q) Draw Page Layout Formulas Data Review View Automate Help Data Mining Editing Share Comments Catch up File Home Insert = v 11 A" A E al Wrap Text General O G Calibri E = Insert Delete Format Editing Analyze Show Paste BIUDab VA Merge & Center $ ~ % 9 08 -20 Conditional Format As Styles Formatting Table v Data ToolPak Cells Analysis Commands Group Undo Clipboard Font Alignment Number Styles D1 fx K L M N O P Q R B C D E F G H A Weekly Gross Televison Newspaper Revenue Advertising Advertising ($1000s) ($1000s) ($1000s) 96 5 1.5 IN 90 2 2 95 4 1.5 92 2.5 2.5 UT 95 3 3.3 94 3.5 2.3 94 2.5 4.2 6 00 94 3 2.5 10 11 12 w 14 15 16 17 18 19 20 21 E Sheet1 + Give Feedback to Microsoft 100% + Calculation Mode: Automatic Workbook Statistics 8:52 PM Type here to search X E3 O 46OF Clear 12/9/2022MindTap , Cengage Learning 7 C i ng.cengage.com Cecilia v My Home Courses Catalog and Study Tools Rental Options College Success Tips Career Success Tips Help Give Feedback /0 Type here to search n'iei'ii: cl ':~ CENGAGE MINDTAP 15.6 Practice Questions Click on the datafile logo to reference the data. DATA \"Hzy The estimated regression equation was thousand decimals). thousand, $ thousand ) Weekly Gross Revenue ($10005) 96 9O 95 92 95 94 94 94 Television Advertising ($10005) 5.0 2.0 4.0 2.5 3.0 3.5 2.5 3.0 :1] : 83.23 + 2.29371 + 1.30222 3. What is the gross revenue expected for a week where $3,500 is spent on television ($1 : 3.5) and $1,800 is spent on newspaper advertising (m2 = 1.8) (to 3 decimals)? Exercise 15.29 (Using the Estimated Regression Equation for Estimation and Prediction) The owner of Showtime Movie Theaters, Inc., used multiple regression analysis to predict gross revenue (y) as a function of television advertising (271) and newspaper advertising (22). Values of y, 271, and 32 are expressed in thousands of dollars. Newspaper Advertising ($10005) 1,5 2.0 1,5 2.5 3,3 2.3 4,2 2.5 b. PrDVIde a 95% prediction interval for next week's revenue, assuming that the advertising expenditures will be allocated as in part (a) (to 2 Q Search this course 0X Question 1 of2 D Check My Work 8152 PM A El 4; 1 2/9/2022 J 46"F Clear