https://teststmarytx-my.sharepoint.com/:x:/g/personal/rfrazier4_mail_stmarytx_edu/Ea_g04aFWjlNiMzRIAChFYYB_S9dA8fDOf0_xhOE4sNDyQ?e=yF8NMl

Solutions for problems whose numbers appear within a colored box can be found in the Student Solution Files. Level A 26. 27. In a study of housing demand, a county assessor is inter- ested in developing a regression model to estimate the selling price of residential properties within her jurisdic- tion. She randomly selects several houses and records the selling price in addition to the following values: the size of the house (in square feet), the total number of rooms in the house, the age of the house, and an indica- tion of whether the house has an attached garage. These data are stored in the le P10_26.xlsx. a.Estimate and interpret a multiple regression equation that includes the four potential explanatory variables. How do you interpret the coefcient of the Attached Garage variable? b. Evaluate the estimated regression equation's goodness of t. c. Use the estimated equation to predict the sales price of a 3000-square-foot, 20-year-old home that has seven rooms but no attached garage. How accurate is your prediction? A manager of boiler drums wants to use regression anal- ysis to predict the number of worker-hours needed to erect the drums in future projects. Data for several ran domly selected boilers have been collected. In addition to workerhours (Y), the variables measured include boiler capacity, boiler design pressure, boiler type, and 28. drum type. All of these measurements are listed in the le P10_27.xlsx. a.Estimate an appropriate multiple regression equation to predict the number of worker-hours needed to erect boiler drums. b. Interpret the estimated regression coefficients. c.According to the estimated regression equation, what is the difference between the mean number of workerhours required for erecting industrial and util ity eld boilers? d.According to the estimated regression equation, what is the difference between the mean number of work- er-hours required for erecting boilers with steam drums and those with mud drums? 2. Given the estimated regression equation, predict the number of worker-hours needed to erect a utility-eld, steam-drum boiler with a capacity of 550,000 pounds per hour and a design pressure of 1400 pounds per square inch. How accurate is your prediction? f. Given the estimated regression equation, predict the number of worker-hours needed to erect an industrial-eld, mud-drum boiler with a capacity of 100,000 pounds per hour and a design pressure of 1000 pounds per square inch. How accurate is your prediction? Suppose that a regional express delivery service com- pany wants to estimate the cost of shipping a pack- age (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragw ile, and durable. Costs for several randomly chosen packages of approximately the same weight and same