Tucson Machinery, Ic., manufactures numerically controlled machines, which sell for an average price of $11.0 million each. Sales for these NCMS for the past two years were as follows: Use Exhibit...

Tucson Machinery, Ic., manufactures numerically controlled machines, which sell for an average price of $11.0 million each. Sales for<br>these NCMS for the past two years were as follows: Use Exhibit 3.10.<br>QUANTITY<br>QUANTITY<br>QUARTER<br>(UNITS)<br>QUARTER<br>THIS YEAR<br>(UNITS)<br>LAST YEAR<br>I<br>11<br>I<br>14<br>II<br>18<br>II<br>23<br>III<br>25<br>III<br>27<br>IV<br>15<br>IV<br>21<br>a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.)<br>Y =<br>t<br>b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round intermediate calculations.<br>Round your answers to 3 decimal places.)<br>Seasonal<br>Factors<br>Period<br>Trend Forecast<br>Last Year<br>II<br>II<br>IV<br>This Year<br>II<br>II<br>IV<br>

Extracted text: Tucson Machinery, Ic., manufactures numerically controlled machines, which sell for an average price of $11.0 million each. Sales for these NCMS for the past two years were as follows: Use Exhibit 3.10. QUANTITY QUANTITY QUARTER (UNITS) QUARTER THIS YEAR (UNITS) LAST YEAR I 11 I 14 II 18 II 23 III 25 III 27 IV 15 IV 21 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) Y = t 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.) Seasonal Factors Period Trend Forecast Last Year II II IV This Year II II IV

Jun 09, 2022

SOLUTION.PDF

Tucson Machinery, Ic., manufactures numerically controlled machines, which sell for an average price of $11.0 million each. Sales for these NCMS for the past two years were as follows: Use Exhibit...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment