The number of students enrolled in Spring Valley Elementary school has been steadily increasing over the past five years. The School Board would like to forecast enrolment for years 6 and 7 in order to better plan capacity. The past five years enrolment is indicated in table 3: Table 3 Year Enrollment 1 220 2 245 3 256 4 289 5 310 Assuming a linear trend, use the tabular method to derive values for: the slope the intercept How did you work out to get 22.4 for the slope and for the intercept how did you work it out and get 196.8
The number of students enrolled in Spring Valley Elementary school has been steadily increasing over the past five years. The School Board would like to forecast enrolment for years 6 and 7 in order to better plan capacity. The past five years enrolment is indicated in table 3: Table 3 Year Enrollment 1 220 2 245 3 256 4 289 5 310 Assuming a linear trend, use the tabular method to derive values for: the slope the intercept How did you work out to get 22.4 for the slope and for the intercept how did you work it out and get 196.8
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 30P: A company manufacturers a product in the United States and sells it in England. The unit cost of...
Related questions
Question
- The number of students enrolled in Spring Valley Elementary school has been steadily increasing over the past five years. The School Board would like to
forecast enrolment
for years 6 and 7 in order to better plan capacity. The past five years enrolment is indicated in table 3:
Table 3
Year |
Enrollment |
1 |
220 |
2 |
245 |
3 |
256 |
4 |
289 |
5 |
310 |
Assuming a linear trend, use the tabular method to derive values for:
- the slope
- the intercept
How did you work out to get 22.4 for the slope and for the intercept how did you work it out and get 196.8
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,