Question: All the same question, just to big for 1 picture Tucson Machinery, Inc,, manufactures numerically controlled machines, which sell for an average price of $0.5million
All the same question, just to big for 1 picture
Tucson Machinery, Inc,, manufactures numerically controlled machines, which sell for an average price of $0.5million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 18.10. a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round intermediate calculations. Round your answers to 3 decimal places.) c. Forecast sales for next year using the above seasonal factors. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
