Question
Tucson Machinery, Inc., manufactures numerically controlled machines (NCM), which sell for an average price of $12 million each. Sales for these NCMs for the past
Tucson Machinery, Inc., manufactures numerically controlled machines (NCM), which sell for an average price of $12 million each. Sales for these NCMs for the past two years were as follows:
| Quarter Last year | Quantity (units) | Quarter This year | Quantity (units) |
| I | 12 | I | 20 |
| II | 18 | II | 24 |
| III | 20 | III | 28 |
| IV | 24 | IV | 32 |
Find the equation of a simple linear regression line using Excel, in the format of Y=a+bX. Keep two decimals of a and b.
Forecast the first quarter sales for next year. Keep two decimals.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Public Finance
Authors: H L Bhatia
30th Edition
9390080258, 978-9390080250
