Due to a recent change by Microsoft you will need to open the XL Miner Analysis ToolPak add-in manually from the home ribbon Screenshot of ToolPak The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XL Miner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet. 353 X Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue - 18 TVAdv b. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals), Revenue- 04 19 2.35% TVAV 104 NewsAdv C. Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)? No the coefficients are not the same v d. Predict weekly gross revenue for a week when $5.2 thousand is spent on television advertising and 53.5 thousand is spent on newspaper advertising (to 2 decimals) Delete this text en place your implo Regression put in a shadedres Op 651 Weeky Grow Revenue (1000) 97 11 16 Television Advertising (51000) 6 3 5 25 Newspaper Advertising (51000) 15 2 15 25 96 00 35 225 4 23 42 25 10 Predicted Revenue (Part ) Formula for Predicted Revenue WA Delete a fost the place your Multi Region out in this shaded Output SES21 4 Sheet Complete the equation below for an estimated regression equation developed to predict the average number of runs given up per inning pitched (R/IP) given the average number of strikeouts per inning pitched (SO/IP) and the average number of home runs per inning pitched (HR/IP) (to 3 decimals). R/IP SO/IP HR/IP a. Use the F test to determine the overall significance of the relationship. Compute F test statistic (to 2 decimals). The p-value is (to 3 decimals) What is your conclusion at the .05 level of significance? There va significant overall relationship. b. Use the t test to determine the significance of each independent variables Compute the t test statistic for the significance of SO/IP (to 2 decimals) The p-value is (to 3 decimals) What is your conclusion at the .05 level of sionificance SO/IP significant Comoute the t test statistic for the sionificance of HR/IP to 2 deomats What is your conclusion at the .05 level of significance? There a significant overall relationship. b. Use the t test to determine the significance of each independent variable. Compute the t test statistic for the significance of SO/IP (to 2 decimals), The p-value is (to 3 decimals). What is your conclusion at the .05 level of significance? SO/IP significant Compute the t test statistic for the significance of HR/IP (to 2 decimals), The p-value is (to 3 decimals) What is your conclusion at the .05 level of significance? HR/IP significant E ERA 239 200 2 SOAP 1.00 091 0.91 H RAP 0.29 0.34 0.40 0.36 07 w 24 13 16 15 16 9 11 15 14 13 9 10 3 12 Player Verlander, Beckett Wilson Sabatha, Haren. McCarthy Santana, Lester Hernandez Buche M Pineda M Colon, Tamil Pavano Danks Guthie Lewis Scherze M Davis Porcel A reading this content in this shaded Use XL Miner Analysis tool to conduct you Linear Rossionais ARer deleting all text in this shaded areas that in the other la colla Your Linnat Regression analysis of shoulder to the wa Team DET BOS TEX NYY LAR LAA BOS SEA CWS SEA NYY CLE MIN CWS BAL TEX DET TB DET 300 3.17 30 3137 34 3.46 350 37 400 425 4.30 0.80 071 0.78 0.95 095 0.53 101 HRAIP 0.00 0.10 0.06 0.07 008 005 0.10 009 0.07 0.09 10 0.12 014 0909 0.11 0.12 0.17 0.13 0.12 0.10 14 9 10 10 7 13 12 1 10 9 10 9 02 0.45 12 9 8 9 14 15 11 0.53 046 0.79 063 052 0.47 054 0.51 054 050 352 32 3 443 05 057 0:57 052 41 0157 The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet. X Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue 85.8 1.8 X TVAdv b. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals). Revenue 84.19 2.35 TVAdy + 1.04 X NewsAdv c. Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b) No, the coefficients are not the same v d. Predict weekly gross revenue for a week when $5.2 thousand is spent on television advertising and $3.5 thousand is spent on newspaper advertising (to 2 decimals)? 94.62 In thousands Weekly Cross Revenue (1000) Television Advertising ($1000) Delete this food then place your Simple Regression output in this shaded Output range SES1 Newspaper Advertising (51000) 15 2 1.5 18288899 3 5 25 4 25 25 4 33 23 42 25 Predicted Revenue (Part D) 35 Fomu for Predicted one Delete this beat the place your Multiple Regression out in this shaded area. Output range SE$21 Major League Baseball (MLB) consists of teams that play in the American League and the National League. MLB collects a wide variety of team and player statistics. Some of the statistics often used to evaluate pitching performance are as follows: ERA: The average number of earned runs given up by the pitcher per nine innings. An earned run is any run that the opponent scores off a particular pitcher except for runs scored as a result of errors. SO/IP: The average number of strikeouts per inning pitched. HR/IP: The average number of home runs per inning pitched. R/IP: The number of runs given up per inning pitched. The data in the Excel Online file below show values for these statistics for a random sample of 20 pitchers from the American League for a season. Construct a spreadsheet to answer the following questions, Open spreadsheet Complete the equation below for an estimated regression equation developed to predict the average number of runs given up per inning pitched (R/IP) given the average number of strikeouts per inning pitched (SO/IP) and the average number home runs per inning pitched (HR/IP) (to 3 decimals). R/IP = 0.537 9 + 0.308 SO/IP.135 HR/IP a. Use the F test to determine the overall significance of the relationship. Compute F test statistic (to 2 decimals) 0582 The p-value is 0.533 (to 3 decimals) What is your conclusion at the .05 level of significance There is a significant overall relationship. b. Use the t test to determine the significance of each independent variable. Compute the t test statistic for the significance of So/IP (to 2 decimals). The p-value is 7.33 (to 3 decimals). What is your conclusion at the .05 level of significance? SO/IP is significant Compute the t test statistic for the significance of HR/IP (to 2 decimals). 0.48 3 The p-value is 0.48 (to 3 decimals). What is your conclusion at the .05 level of significance? HR/IP is significant w ERA - 30/ 100 051 09 HRUP 0.00 010 0:25 13 10 13 16 250 2254 3100 17 32 1 COM 00 036 Aheaded this Uth XL Mie Analysis to conduct our they Aberdeeting with the that the 21 Your interession analysis 080 671 10 00 12 90 900 OLO 60 LOO 1 10 Pierre Team Verlande DET Hecken, BO TE Sabat NY HD UA Carthy Banana LA BO Hamante SEA WS Pada DEA Colon NY Taman CLE Pax MI CWE DAL TEX M OLI Dails TE DET 2 3 35 3 400 096 12 00 DO D 10 10 00 CHO 010 012 14 052 10 1 12 20 065 DO D. 063 5 011 2 10 139 054 05 54 50 05 19 St 11 45 25 Due to a recent change by Microsoft you will need to open the XL Miner Analysis ToolPak add-in manually from the home ribbon Screenshot of ToolPak The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XL Miner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet. 353 X Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue - 18 TVAdv b. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals), Revenue- 04 19 2.35% TVAV 104 NewsAdv C. Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)? No the coefficients are not the same v d. Predict weekly gross revenue for a week when $5.2 thousand is spent on television advertising and 53.5 thousand is spent on newspaper advertising (to 2 decimals) Delete this text en place your implo Regression put in a shadedres Op 651 Weeky Grow Revenue (1000) 97 11 16 Television Advertising (51000) 6 3 5 25 Newspaper Advertising (51000) 15 2 15 25 96 00 35 225 4 23 42 25 10 Predicted Revenue (Part ) Formula for Predicted Revenue WA Delete a fost the place your Multi Region out in this shaded Output SES21 4 Sheet Complete the equation below for an estimated regression equation developed to predict the average number of runs given up per inning pitched (R/IP) given the average number of strikeouts per inning pitched (SO/IP) and the average number of home runs per inning pitched (HR/IP) (to 3 decimals). R/IP SO/IP HR/IP a. Use the F test to determine the overall significance of the relationship. Compute F test statistic (to 2 decimals). The p-value is (to 3 decimals) What is your conclusion at the .05 level of significance? There va significant overall relationship. b. Use the t test to determine the significance of each independent variables Compute the t test statistic for the significance of SO/IP (to 2 decimals) The p-value is (to 3 decimals) What is your conclusion at the .05 level of sionificance SO/IP significant Comoute the t test statistic for the sionificance of HR/IP to 2 deomats What is your conclusion at the .05 level of significance? There a significant overall relationship. b. Use the t test to determine the significance of each independent variable. Compute the t test statistic for the significance of SO/IP (to 2 decimals), The p-value is (to 3 decimals). What is your conclusion at the .05 level of significance? SO/IP significant Compute the t test statistic for the significance of HR/IP (to 2 decimals), The p-value is (to 3 decimals) What is your conclusion at the .05 level of significance? HR/IP significant E ERA 239 200 2 SOAP 1.00 091 0.91 H RAP 0.29 0.34 0.40 0.36 07 w 24 13 16 15 16 9 11 15 14 13 9 10 3 12 Player Verlander, Beckett Wilson Sabatha, Haren. McCarthy Santana, Lester Hernandez Buche M Pineda M Colon, Tamil Pavano Danks Guthie Lewis Scherze M Davis Porcel A reading this content in this shaded Use XL Miner Analysis tool to conduct you Linear Rossionais ARer deleting all text in this shaded areas that in the other la colla Your Linnat Regression analysis of shoulder to the wa Team DET BOS TEX NYY LAR LAA BOS SEA CWS SEA NYY CLE MIN CWS BAL TEX DET TB DET 300 3.17 30 3137 34 3.46 350 37 400 425 4.30 0.80 071 0.78 0.95 095 0.53 101 HRAIP 0.00 0.10 0.06 0.07 008 005 0.10 009 0.07 0.09 10 0.12 014 0909 0.11 0.12 0.17 0.13 0.12 0.10 14 9 10 10 7 13 12 1 10 9 10 9 02 0.45 12 9 8 9 14 15 11 0.53 046 0.79 063 052 0.47 054 0.51 054 050 352 32 3 443 05 057 0:57 052 41 0157 The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet. X Open spreadsheet a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue 85.8 1.8 X TVAdv b. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals). Revenue 84.19 2.35 TVAdy + 1.04 X NewsAdv c. Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b) No, the coefficients are not the same v d. Predict weekly gross revenue for a week when $5.2 thousand is spent on television advertising and $3.5 thousand is spent on newspaper advertising (to 2 decimals)? 94.62 In thousands Weekly Cross Revenue (1000) Television Advertising ($1000) Delete this food then place your Simple Regression output in this shaded Output range SES1 Newspaper Advertising (51000) 15 2 1.5 18288899 3 5 25 4 25 25 4 33 23 42 25 Predicted Revenue (Part D) 35 Fomu for Predicted one Delete this beat the place your Multiple Regression out in this shaded area. Output range SE$21 Major League Baseball (MLB) consists of teams that play in the American League and the National League. MLB collects a wide variety of team and player statistics. Some of the statistics often used to evaluate pitching performance are as follows: ERA: The average number of earned runs given up by the pitcher per nine innings. An earned run is any run that the opponent scores off a particular pitcher except for runs scored as a result of errors. SO/IP: The average number of strikeouts per inning pitched. HR/IP: The average number of home runs per inning pitched. R/IP: The number of runs given up per inning pitched. The data in the Excel Online file below show values for these statistics for a random sample of 20 pitchers from the American League for a season. Construct a spreadsheet to answer the following questions, Open spreadsheet Complete the equation below for an estimated regression equation developed to predict the average number of runs given up per inning pitched (R/IP) given the average number of strikeouts per inning pitched (SO/IP) and the average number home runs per inning pitched (HR/IP) (to 3 decimals). R/IP = 0.537 9 + 0.308 SO/IP.135 HR/IP a. Use the F test to determine the overall significance of the relationship. Compute F test statistic (to 2 decimals) 0582 The p-value is 0.533 (to 3 decimals) What is your conclusion at the .05 level of significance There is a significant overall relationship. b. Use the t test to determine the significance of each independent variable. Compute the t test statistic for the significance of So/IP (to 2 decimals). The p-value is 7.33 (to 3 decimals). What is your conclusion at the .05 level of significance? SO/IP is significant Compute the t test statistic for the significance of HR/IP (to 2 decimals). 0.48 3 The p-value is 0.48 (to 3 decimals). What is your conclusion at the .05 level of significance? HR/IP is significant w ERA - 30/ 100 051 09 HRUP 0.00 010 0:25 13 10 13 16 250 2254 3100 17 32 1 COM 00 036 Aheaded this Uth XL Mie Analysis to conduct our they Aberdeeting with the that the 21 Your interession analysis 080 671 10 00 12 90 900 OLO 60 LOO 1 10 Pierre Team Verlande DET Hecken, BO TE Sabat NY HD UA Carthy Banana LA BO Hamante SEA WS Pada DEA Colon NY Taman CLE Pax MI CWE DAL TEX M OLI Dails TE DET 2 3 35 3 400 096 12 00 DO D 10 10 00 CHO 010 012 14 052 10 1 12 20 065 DO D. 063 5 011 2 10 139 054 05 54 50 05 19 St 11 45 25