Question: 1.A manager is trying to estimate costs. Three variables impact costs and are identified as: x1, x2, x3. a. USE Worksheet Q1-Part-A . Estimate the

1.A manager is trying to estimate costs. Three variables impact costs and are identified as: x1, x2, x3.

a.USE Worksheet Q1-Part-A. Estimate the linear model Cost = ?0 + ?1x1 + ?2x2 + ?3x3 + ?. Place results in cell J1. What is the predicted cost in a week during which x1 is 25, x2 is 28, and x3 is 75?

b.USE Worksheet Q1-Part-B. Estimate the exponential model. Place results in cell J1. What is the predicted cost in a week during which x1 is 38, x2 is 23, and x3 is 44?

c.USE Worksheet Q1-Part-C. Estimate the log-log model with x2 and x3 transformed. Place results in cell J1. What is the predicted cost in a week during which x1 is 65, x2 is 15, and x3 is 63?

d.Based on the explanatory power of the model which model provides the better fit? Do not make a fiat statement; provide evidence for your conclusion.

1.A manager is trying to estimate costs. Three variables impact costs and

Cost x1 28469.9 13431.7 22994.2 19963.1 49713.1 14453.4 33617.5 39169.7 26979 26866.8 16059.9 40592.6 28896.6 17873.8 40145.5 26547.2 28017.7 24378 25751.6 35601.4 23837.4 49167.4 11697.7 13186.9 31368.4 31557.1 24031.2 17170 38513.5 19359.6 21216 17290.7 14546.9 41286.2 18858.1 55345.2 15245.6 17170 18599.7 26870.2 25634.3 19165.8 31484 29384.5 35139 27982 44881.7 x2 34.5 23.25 50.25 32.25 75 42.75 57 53.25 17.25 45 21 58.5 54 16.5 37.5 52.5 66.75 24.75 22.5 41.25 53.25 56.25 39 22.5 61.5 28.5 62.25 24.75 68.25 30.75 22.5 21 21.75 51.75 27 48.75 46.5 47.25 59.25 32.25 30 54 60 33.75 63.75 46.5 73.5 x3 16.5 18 18.75 21 21.75 21 18.75 22.5 19.5 18.75 21.75 18.75 18 18 19.5 17.25 18.75 20.25 21 18 21.75 18.75 16.5 16.5 18.75 21.75 18.75 17.25 21.75 15 20.25 16.5 15 22.5 16.5 21 17.25 20.25 18 19.5 21 18.75 17.25 18.75 15.75 15.75 20.25 56.25 73.5 64.5 64.5 61.5 70.5 55.5 52.5 49.5 54.75 71.25 61.5 60 54.75 49.5 55.5 74.25 69.75 50.25 54 64.5 53.25 74.25 66 55.5 49.5 73.5 57 55.5 56.25 54.75 62.25 54.75 55.5 52.5 48.75 71.25 69.75 70.5 49.5 49.5 63 51 69 59.25 46.5 48.75 26010 23125.1 20360.9 50303 25156.6 15373.1 20733.2 24078.8 38295.9 29170.3 28277.8 18985.6 32760.7 11427.4 47010.1 21409.8 35489.2 41544.6 24777.5 21753.2 18314.1 17734.4 13822.7 16299.6 25059.7 35258 18292 30205.6 20901.5 14791.7 34093.5 13615.3 19346 22775.92 10745.36 18395.36 15970.48 39770.48 11562.72 26894 31335.76 21583.2 21493.44 12847.92 32474.08 23117.28 14299.04 32116.4 30.75 32.25 39 66.75 45 22.5 45 44.25 52.5 66.75 68.25 34.5 33 16.5 63.75 57 57 72.75 17.25 33.75 72.75 39 47.25 34.5 38.25 68.25 47.25 60.75 28.5 53.25 72 33 42 20.7 13.95 30.15 19.35 45 25.65 34.2 31.95 10.35 27 12.6 35.1 32.4 9.9 22.5 18 19.5 17.25 17.25 17.25 21 15.75 16.5 21 16.5 17.25 21.75 18 16.5 21 15.75 22.5 19.5 16.5 21 18 15.75 15 18 21 19.5 17.25 21 21 15.75 16.5 18.75 21 9.9 10.8 11.25 12.6 13.05 12.6 11.25 13.5 11.7 11.25 13.05 11.25 10.8 10.8 11.7 58.5 56.25 71.25 46.5 60.75 69 67.5 59.25 48.75 72.75 54.75 70.5 45 73.5 50.25 72.75 50.25 47.25 61.5 61.5 71.25 49.5 71.25 74.25 49.5 66 63 67.5 54.75 73.5 60.75 72 63 33.75 44.1 38.7 38.7 36.9 42.3 33.3 31.5 29.7 32.85 42.75 36.9 36 32.85 29.7 21237.76 22414.16 19502.4 20601.28 28481.12 19069.92 39333.92 9358.16 10549.52 25094.72 25245.68 19224.96 13736 30810.8 15487.68 16972.8 13832.56 11637.52 33028.96 15086.48 44276.16 12196.48 13736 14879.76 21496.16 20507.44 15332.64 25187.2 23507.6 28111.2 22385.6 35905.36 20808 18500.08 16288.72 40242.4 20125.28 12298.48 16586.56 19263.04 30636.72 23336.24 22622.24 15188.48 26208.56 9141.92 37608.08 17127.84 31.5 40.05 14.85 13.5 24.75 31.95 33.75 23.4 13.5 36.9 17.1 37.35 14.85 40.95 18.45 13.5 12.6 13.05 31.05 16.2 29.25 27.9 28.35 35.55 19.35 18 32.4 36 20.25 38.25 27.9 44.1 18.45 19.35 23.4 40.05 27 13.5 27 26.55 31.5 40.05 40.95 20.7 19.8 9.9 38.25 34.2 10.35 11.25 12.15 12.6 10.8 13.05 11.25 9.9 9.9 11.25 13.05 11.25 10.35 13.05 9 12.15 9.9 9 13.5 9.9 12.6 10.35 12.15 10.8 11.7 12.6 11.25 10.35 11.25 9.45 9.45 12.15 10.8 11.7 10.35 10.35 10.35 12.6 9.45 9.9 12.6 9.9 10.35 13.05 10.8 9.9 12.6 9.45 33.3 44.55 41.85 30.15 32.4 38.7 31.95 44.55 39.6 33.3 29.7 44.1 34.2 33.3 33.75 32.85 37.35 32.85 33.3 31.5 29.25 42.75 41.85 42.3 29.7 29.7 37.8 30.6 41.4 35.55 27.9 29.25 35.1 33.75 42.75 27.9 36.45 41.4 40.5 35.55 29.25 43.65 32.85 42.3 27 44.1 30.15 43.65 28391.36 33235.68 19822 17402.56 14651.28 14187.52 11058.16 34.2 43.65 10.35 20.25 43.65 23.4 28.35 13.5 11.7 9.9 12.6 10.8 9.45 9 30.15 28.35 36.9 36.9 42.75 29.7 42.75 Cost x1 28469.9 13431.7 22994.2 19963.1 49713.1 14453.4 33617.5 39169.7 26979 26866.8 16059.9 40592.6 28896.6 17873.8 40145.5 26547.2 28017.7 24378 25751.6 35601.4 23837.4 49167.4 11697.7 13186.9 31368.4 31557.1 24031.2 17170 38513.5 19359.6 21216 17290.7 14546.9 41286.2 18858.1 55345.2 15245.6 17170 18599.7 26870.2 25634.3 19165.8 31484 29384.5 35139 27982 44881.7 x2 34.5 23.25 50.25 32.25 75 42.75 57 53.25 17.25 45 21 58.5 54 16.5 37.5 52.5 66.75 24.75 22.5 41.25 53.25 56.25 39 22.5 61.5 28.5 62.25 24.75 68.25 30.75 22.5 21 21.75 51.75 27 48.75 46.5 47.25 59.25 32.25 30 54 60 33.75 63.75 46.5 73.5 x3 16.5 18 18.75 21 21.75 21 18.75 22.5 19.5 18.75 21.75 18.75 18 18 19.5 17.25 18.75 20.25 21 18 21.75 18.75 16.5 16.5 18.75 21.75 18.75 17.25 21.75 15 20.25 16.5 15 22.5 16.5 21 17.25 20.25 18 19.5 21 18.75 17.25 18.75 15.75 15.75 20.25 56.25 73.5 64.5 64.5 61.5 70.5 55.5 52.5 49.5 54.75 71.25 61.5 60 54.75 49.5 55.5 74.25 69.75 50.25 54 64.5 53.25 74.25 66 55.5 49.5 73.5 57 55.5 56.25 54.75 62.25 54.75 55.5 52.5 48.75 71.25 69.75 70.5 49.5 49.5 63 51 69 59.25 46.5 48.75 26010 23125.1 20360.9 50303 25156.6 15373.1 20733.2 24078.8 38295.9 29170.3 28277.8 18985.6 32760.7 11427.4 47010.1 21409.8 35489.2 41544.6 24777.5 21753.2 18314.1 17734.4 13822.7 16299.6 25059.7 35258 18292 30205.6 20901.5 14791.7 34093.5 13615.3 19346 22775.92 10745.36 18395.36 15970.48 39770.48 11562.72 26894 31335.76 21583.2 21493.44 12847.92 32474.08 23117.28 14299.04 32116.4 30.75 32.25 39 66.75 45 22.5 45 44.25 52.5 66.75 68.25 34.5 33 16.5 63.75 57 57 72.75 17.25 33.75 72.75 39 47.25 34.5 38.25 68.25 47.25 60.75 28.5 53.25 72 33 42 20.7 13.95 30.15 19.35 45 25.65 34.2 31.95 10.35 27 12.6 35.1 32.4 9.9 22.5 18 19.5 17.25 17.25 17.25 21 15.75 16.5 21 16.5 17.25 21.75 18 16.5 21 15.75 22.5 19.5 16.5 21 18 15.75 15 18 21 19.5 17.25 21 21 15.75 16.5 18.75 21 9.9 10.8 11.25 12.6 13.05 12.6 11.25 13.5 11.7 11.25 13.05 11.25 10.8 10.8 11.7 58.5 56.25 71.25 46.5 60.75 69 67.5 59.25 48.75 72.75 54.75 70.5 45 73.5 50.25 72.75 50.25 47.25 61.5 61.5 71.25 49.5 71.25 74.25 49.5 66 63 67.5 54.75 73.5 60.75 72 63 33.75 44.1 38.7 38.7 36.9 42.3 33.3 31.5 29.7 32.85 42.75 36.9 36 32.85 29.7 21237.76 22414.16 19502.4 20601.28 28481.12 19069.92 39333.92 9358.16 10549.52 25094.72 25245.68 19224.96 13736 30810.8 15487.68 16972.8 13832.56 11637.52 33028.96 15086.48 44276.16 12196.48 13736 14879.76 21496.16 20507.44 15332.64 25187.2 23507.6 28111.2 22385.6 35905.36 20808 18500.08 16288.72 40242.4 20125.28 12298.48 16586.56 19263.04 30636.72 23336.24 22622.24 15188.48 26208.56 9141.92 37608.08 17127.84 31.5 40.05 14.85 13.5 24.75 31.95 33.75 23.4 13.5 36.9 17.1 37.35 14.85 40.95 18.45 13.5 12.6 13.05 31.05 16.2 29.25 27.9 28.35 35.55 19.35 18 32.4 36 20.25 38.25 27.9 44.1 18.45 19.35 23.4 40.05 27 13.5 27 26.55 31.5 40.05 40.95 20.7 19.8 9.9 38.25 34.2 10.35 11.25 12.15 12.6 10.8 13.05 11.25 9.9 9.9 11.25 13.05 11.25 10.35 13.05 9 12.15 9.9 9 13.5 9.9 12.6 10.35 12.15 10.8 11.7 12.6 11.25 10.35 11.25 9.45 9.45 12.15 10.8 11.7 10.35 10.35 10.35 12.6 9.45 9.9 12.6 9.9 10.35 13.05 10.8 9.9 12.6 9.45 33.3 44.55 41.85 30.15 32.4 38.7 31.95 44.55 39.6 33.3 29.7 44.1 34.2 33.3 33.75 32.85 37.35 32.85 33.3 31.5 29.25 42.75 41.85 42.3 29.7 29.7 37.8 30.6 41.4 35.55 27.9 29.25 35.1 33.75 42.75 27.9 36.45 41.4 40.5 35.55 29.25 43.65 32.85 42.3 27 44.1 30.15 43.65 28391.36 33235.68 19822 17402.56 14651.28 14187.52 11058.16 34.2 43.65 10.35 20.25 43.65 23.4 28.35 13.5 11.7 9.9 12.6 10.8 9.45 9 30.15 28.35 36.9 36.9 42.75 29.7 42.75 Cost x1 28469.9 13431.7 22994.2 19963.1 49713.1 14453.4 33617.5 39169.7 26979 26866.8 16059.9 40592.6 28896.6 17873.8 40145.5 26547.2 28017.7 24378 25751.6 35601.4 23837.4 49167.4 11697.7 13186.9 31368.4 31557.1 24031.2 17170 38513.5 19359.6 21216 17290.7 14546.9 41286.2 18858.1 55345.2 15245.6 17170 18599.7 26870.2 25634.3 19165.8 31484 29384.5 35139 27982 44881.7 x2 34.5 23.25 50.25 32.25 75 42.75 57 53.25 17.25 45 21 58.5 54 16.5 37.5 52.5 66.75 24.75 22.5 41.25 53.25 56.25 39 22.5 61.5 28.5 62.25 24.75 68.25 30.75 22.5 21 21.75 51.75 27 48.75 46.5 47.25 59.25 32.25 30 54 60 33.75 63.75 46.5 73.5 x3 16.5 18 18.75 21 21.75 21 18.75 22.5 19.5 18.75 21.75 18.75 18 18 19.5 17.25 18.75 20.25 21 18 21.75 18.75 16.5 16.5 18.75 21.75 18.75 17.25 21.75 15 20.25 16.5 15 22.5 16.5 21 17.25 20.25 18 19.5 21 18.75 17.25 18.75 15.75 15.75 20.25 56.25 73.5 64.5 64.5 61.5 70.5 55.5 52.5 49.5 54.75 71.25 61.5 60 54.75 49.5 55.5 74.25 69.75 50.25 54 64.5 53.25 74.25 66 55.5 49.5 73.5 57 55.5 56.25 54.75 62.25 54.75 55.5 52.5 48.75 71.25 69.75 70.5 49.5 49.5 63 51 69 59.25 46.5 48.75 26010 23125.1 20360.9 50303 25156.6 15373.1 20733.2 24078.8 38295.9 29170.3 28277.8 18985.6 32760.7 11427.4 47010.1 21409.8 35489.2 41544.6 24777.5 21753.2 18314.1 17734.4 13822.7 16299.6 25059.7 35258 18292 30205.6 20901.5 14791.7 34093.5 13615.3 19346 22775.92 10745.36 18395.36 15970.48 39770.48 11562.72 26894 31335.76 21583.2 21493.44 12847.92 32474.08 23117.28 14299.04 32116.4 30.75 32.25 39 66.75 45 22.5 45 44.25 52.5 66.75 68.25 34.5 33 16.5 63.75 57 57 72.75 17.25 33.75 72.75 39 47.25 34.5 38.25 68.25 47.25 60.75 28.5 53.25 72 33 42 20.7 13.95 30.15 19.35 45 25.65 34.2 31.95 10.35 27 12.6 35.1 32.4 9.9 22.5 18 19.5 17.25 17.25 17.25 21 15.75 16.5 21 16.5 17.25 21.75 18 16.5 21 15.75 22.5 19.5 16.5 21 18 15.75 15 18 21 19.5 17.25 21 21 15.75 16.5 18.75 21 9.9 10.8 11.25 12.6 13.05 12.6 11.25 13.5 11.7 11.25 13.05 11.25 10.8 10.8 11.7 58.5 56.25 71.25 46.5 60.75 69 67.5 59.25 48.75 72.75 54.75 70.5 45 73.5 50.25 72.75 50.25 47.25 61.5 61.5 71.25 49.5 71.25 74.25 49.5 66 63 67.5 54.75 73.5 60.75 72 63 33.75 44.1 38.7 38.7 36.9 42.3 33.3 31.5 29.7 32.85 42.75 36.9 36 32.85 29.7 21237.76 22414.16 19502.4 20601.28 28481.12 19069.92 39333.92 9358.16 10549.52 25094.72 25245.68 19224.96 13736 30810.8 15487.68 16972.8 13832.56 11637.52 33028.96 15086.48 44276.16 12196.48 13736 14879.76 21496.16 20507.44 15332.64 25187.2 23507.6 28111.2 22385.6 35905.36 20808 18500.08 16288.72 40242.4 20125.28 12298.48 16586.56 19263.04 30636.72 23336.24 22622.24 15188.48 26208.56 9141.92 37608.08 17127.84 31.5 40.05 14.85 13.5 24.75 31.95 33.75 23.4 13.5 36.9 17.1 37.35 14.85 40.95 18.45 13.5 12.6 13.05 31.05 16.2 29.25 27.9 28.35 35.55 19.35 18 32.4 36 20.25 38.25 27.9 44.1 18.45 19.35 23.4 40.05 27 13.5 27 26.55 31.5 40.05 40.95 20.7 19.8 9.9 38.25 34.2 10.35 11.25 12.15 12.6 10.8 13.05 11.25 9.9 9.9 11.25 13.05 11.25 10.35 13.05 9 12.15 9.9 9 13.5 9.9 12.6 10.35 12.15 10.8 11.7 12.6 11.25 10.35 11.25 9.45 9.45 12.15 10.8 11.7 10.35 10.35 10.35 12.6 9.45 9.9 12.6 9.9 10.35 13.05 10.8 9.9 12.6 9.45 33.3 44.55 41.85 30.15 32.4 38.7 31.95 44.55 39.6 33.3 29.7 44.1 34.2 33.3 33.75 32.85 37.35 32.85 33.3 31.5 29.25 42.75 41.85 42.3 29.7 29.7 37.8 30.6 41.4 35.55 27.9 29.25 35.1 33.75 42.75 27.9 36.45 41.4 40.5 35.55 29.25 43.65 32.85 42.3 27 44.1 30.15 43.65 28391.36 33235.68 19822 17402.56 14651.28 14187.52 11058.16 34.2 43.65 10.35 20.25 43.65 23.4 28.35 13.5 11.7 9.9 12.6 10.8 9.45 9 30.15 28.35 36.9 36.9 42.75 29.7 42.75

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

In 2017, DelCano Properties paid $540,000 for a tract of land on which two buildings were located. The plan was to demolish Building A and build a new factory (Building C) in its place. Building B...

ecop3 [9:18 AM, 10/23/2021] Flo: Choose a Company's name and background/profile? What is the nature of the business or service provided by the organization? What is its history and mission? How is...

Question: Evaluate the two forecasting models described in the case for predicting daily check-in volume. What are the strengths and weaknesses of each one? Do you find any of the results surprising?...

ecop3 [9:18 AM, 10/23/2021] Flo: Choose a Company's name and background/profile? What is the nature of the business or service provided by the organization? What is its history and mission? How is...

Help me solve these questions answer all questions please Each station's budget for the year ending 30 September. 2018 is as follows: GR1 GR2 GTV Budget 2017/18 Budget 2017/18 Budget 2017/18 Shs...

CUSTOMER RELATIONSHIP MANAGEMENT: ITS DIMENSIONS AND EFFECT ON CUSTOMER OUTCOMES Frederick Hong-kit Yim, Rolph E. Anderson, and Srinivasan Swaminathan Despite the rapidly growing customer...

Hello, I have assessment.. Step 1 : Calculate the following ratios for the latest five years using the O-S Checklist Approach, an Excel template . For an overview of the approach, read our article,...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

My tutor that I Have been using for the past 5 weeks bailed on me with an assignment due tomorrow by 9PM Central USA time. There is 3 weeks left in this course. I am looking for someone that is...

I am stuck working through these can you please help me? Project 1 Name: TYPE in your name here Please use this file as your template to complete project 1 using the Data worksheet to develop...

Select ONE of the following: There are several different formats (emails, letters, reports, slides, and more). How important is the format in connecting with an audience? Defend your answer with...

Acquisition accounting only applies to the acquisition of a business. What are the three elements of a business, per ASC Topic 805? a). assets, liabilities, and equity b). facilities, workforce, and...

James has a mortgage balance of $ 1 5 0 , 0 0 0 . 0 0 at 4 . 6 % compounded semiannually. How much longer will it take to pay off the mortgage with monthly payments of $ 8 5 0 than with monthly...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...