{"id":21674,"date":"2024-04-17T02:11:38","date_gmt":"2024-04-17T02:11:38","guid":{"rendered":"https:\/\/www.writemyessays.app\/blog\/questions\/submit-your-work-using-microsoft-excel-chapter-13-problems-13-73-13-75-chapter-14-problems-14-71-14-72\/"},"modified":"2024-04-17T02:11:38","modified_gmt":"2024-04-17T02:11:38","slug":"submit-your-work-using-microsoft-excel-chapter-13-problems-13-73-13-75-chapter-14-problems-14-71-14-72","status":"publish","type":"questions","link":"https:\/\/www.writemyessays.app\/blog\/questions\/submit-your-work-using-microsoft-excel-chapter-13-problems-13-73-13-75-chapter-14-problems-14-71-14-72\/","title":{"rendered":"Submit your work using Microsoft Excel. Chapter 13 Problems: 13.73, 13.75 Chapter 14 Problems: 14.71, 14.72"},"content":{"rendered":"

Chapter Review Problems
\n13.73 Can you use movie critics\u2019 opinions to forecast box office receipts on the opening weekend? The following data, stored in Tomatometer, indicate the Tomatometer rating, the percentage of professional critic reviews that are positive, and the receipts per theater ($thousands) on the weekend a movie opened for 10 movies:
\nMovie\tTomatometer Rating\tReceipts
\nThe Mummy\t16\t 7.8
\nZookeeper\u2019s Wife\t61\t 6.1
\nBeatriz at Dinner\t80\t28.4
\nThe Hero\t76\t11.3
\nWonder Woman\t93\t24.8
\nBaby Boss\t52\t13.3
\nThe Circle\t15\t 2.9
\nDean\t61\t 4.0
\nBaywatch\t20\t 5.1
\nChurchill\t38\t 1.9
\nSource: <\/p>\n

<\/div>\n
\u201cTop Box Office Movies \u2013 Rotten Tomatoes,\u201d and \u201cThe Numbers \u2013 Weekend Box Office Chart for May 26th 2017,\u201d bit.ly\/2t0tqS6.
\nUse<\/div>\n
<\/div>\n
A. Use the least-squares method to compute the regression coefficients b0 and b1 <\/div>\n
<\/div>\n
B. Interpret the meaning of b0 and b1 in this problem.<\/div>\n
<\/div>\n
C.  Predict the mean receipts for a movie that has a Tomatometer rating of 55%. <\/div>\n
<\/div>\n
D. Should you use the model to predict the receipts for a movie that has a Tomatometer rating of 5%? Why or why not? <\/div>\n
<\/div>\n
E. Determine the coefficient of determination, and explain its meaning in this problem. <\/div>\n
<\/div>\n
F. Perform a residual analysis. Is there any evidence of a pattern in the residuals? Explain.
\nAt the 0.05 level of significance, is there evidence of a linear relationship between Tomatometer rating and receipts? <\/div>\n
<\/div>\n
H. Construct a 95% confidence interval estimate of the mean receipts for a movie that has a Tomatometer rating of 55% and a 95% prediction interval of the receipts for a single movie that has a Tomatometer rating of 55%. <\/div>\n
<\/div>\n
I.  Based on the results of (a)\u2013(h), do you think that Tomatometer rating is a useful predictor of receipts on the first weekend a movie opens? What issues about these data might make you hesitant to use Tomatometer rating to predict receipts?<\/div>\n
<\/div>\n
13.75 Measuring the height of a California redwood tree is very difficult because these trees grow to heights of more than 300 feet. People familiar with these trees understand that the height of a California redwood tree is related to other characteristics of the tree, including the diameter of the tree at the breast height of a person. The data in Redwood represent the height (in feet) and diameter (in inches) at the breast height of a person for a sample of 21 California redwood trees. <\/div>\n
<\/div>\n
A.   Assuming a linear relationship, use the least-squares method to compute the regression coefficients and State the regression equation that predicts the height of a tree based on the tree\u2019s diameter at breast height of a person.<\/div>\n
<\/div>\n
B.    Interpret the meaning of the slope in this equation. <\/div>\n
<\/div>\n
C.  Predict the mean height for a tree that has a breast height diameter of 25 inches. <\/div>\n
<\/div>\n
D.  Interpret the meaning of the coefficient of determination in this problem. <\/div>\n
<\/div>\n
E.  Perform a residual analysis on the results and determine the adequacy of the model. <\/div>\n
<\/div>\n
F.   Determine whether there is a significant relationship between the height of redwood trees and the breast height diameter at the 0.05 level of significance. <\/div>\n
<\/div>\n
G.   Construct a 95% confidence interval estimate of the population slope between the height of the redwood trees and breast height diameter. <\/div>\n
<\/div>\n
H.  What conclusions can you reach about the relationship of the diameter of the tree and its height?<\/div>\n
<\/div>\n
<\/div>\n
Chapter Review Problems
\n14.71 Increasing customer satisfaction typically results in increased purchase behavior. For many products, there is more than one measure of customer satisfaction. In many, purchase behavior can increase dramatically with an increase in just one of the customer satisfaction measures. Gunst and Barry (\u201cOne Way to Moderate Ceiling Effects,\u201d Quality Progress, October 2003, pp. 83\u201385) consider a product with two satisfaction measures, and , that range from the lowest level of satisfaction, 1, to the highest level of satisfaction, 7. The dependent variable, Y, is a measure of purchase behavior, with the highest value generating the most sales. Consider the regression equation:<\/div>\n
<\/div>\n
Y i =-3.888+1.449x1i + 1.462x21i- 0.190x1i x2i<\/div>\n
<\/div>\n
Suppose that is the perceived quality of the product and is the perceived value of the product. (Note: If the customer thinks the product is overpriced, he or she perceives it to be of low value and vice versa.)<\/div>\n
<\/div>\n
A. What is the predicted purchase behavior when x1=2and X2=2<\/div>\n
<\/div>\n
B. What is the predicted purchase behavior when x1=2 and x2=7 <\/div>\n
<\/div>\n
C. What is the predicted purchase behavior when x1=7 and x2=2<\/div>\n
<\/div>\n
D. What is the predicted purchase behavior when x1=7 and x2 =7<\/div>\n
<\/div>\n
E. What is the regression equation when x2=2 What is the slope x1 for now? <\/div>\n
<\/div>\n
F.  What is the regression equation when x2=7 What is the slope for x1 now? <\/div>\n
<\/div>\n
G. What is the regression equation when x1=2 What is the slope for x2 now? <\/div>\n
<\/div>\n
H. What is the regression equation when x1=7What is the slope for x2 now? <\/div>\n
<\/div>\n
I.   Discuss the implications of (a) through (h) in the context of increasing sales for this product with two customer satisfaction measures.<\/div>\n
<\/div>\n
14.72 The owner of a moving company typically has his most experienced manager predict the total number of labor hours that will be required to complete an upcoming move. This approach has proved useful in the past, but the owner has the business objective of developing a more accurate method of predicting labor hours. In a preliminary effort to provide a more accurate method, the owner has decided to use the number of cubic feet moved and the number of pieces of large furniture as the independent variables and has collected data for 36 moves in which the origin and destination were within the borough of Manhattan in New York City and the travel time was an insignificant portion of the hours worked. The data are organized and stored in Moving.<\/div>\n
<\/div>\n
A. State the multiple regression equation. <\/div>\n
B.  mnterpret the meaning of the slopes in this equation. <\/div>\n
C. Predict the mean labor hours for moving 500 cubic feet with two large pieces of furniture. <\/div>\n
<\/div>\n
D. Perform a residual analysis on your model and determine whether the regression assumptions are valid. <\/div>\n
<\/div>\n
E. Determine whether there is a significant relationship between labor hours and the two independent variables (the number of cubic feet moved and the number of pieces of large furniture) at the 0.05 level of significance. <\/div>\n
<\/div>\n
F. Determine the p-value in (e) and interpret its meaning.<\/div>\n
<\/div>\n
G.  Interpret the meaning of the coefficient of multiple determination in this problem. <\/div>\n
<\/div>\n
H. Determine the adjusted r2 <\/span><\/div>\n

<\/span><\/div>\n
I.  At the 0.05 level of significance, determine whether each independent variable makes a significant contribution to the regression model. Indicate the most appropriate regression model for this set of data. <\/span><\/div>\n

<\/span><\/div>\n
J. Determine the p-values in (i) and interpret their meaning. <\/span><\/div>\n

<\/span><\/div>\n
K. Construct a 95% confidence interval estimate of the population slope between labor hours and the number of cubic feet moved. <\/span><\/div>\n

<\/span><\/div>\n
L. Compute and interpret the coefficients of partial determination.<\/span><\/div>\n

<\/span><\/div>\n
M.  What conclusions can you reach concerning labor hours?<\/span><\/div>\n
<\/div>\n
 <\/div>\n","protected":false},"excerpt":{"rendered":"

Chapter Review Problems 13.73 Can you use movie critics\u2019 opinions to forecast box office receipts on the opening weekend? The following data, stored in Tomatometer, indicate the Tomatometer rating, the percentage of professional critic reviews that are positive, and the receipts per theater ($thousands) on the weekend a movie opened for 10 movies: Movie Tomatometer […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[8],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/21674"}],"collection":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/comments?post=21674"}],"version-history":[{"count":0,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/21674\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/media?parent=21674"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/disciplines?post=21674"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/paper_types?post=21674"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/tagged?post=21674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}