Question

Year |
Period (t) |
Enrollment(1,000s) |

2001 | 1 | 6.5 |

2002 | 2 | 8.1 |

2003 | 3 | 8.4 |

2004 | 4 | 10.2 |

2005 | 5 | 12.5 |

2006 | 6 | 13.3 |

2007 | 7 | 13.7 |

2008 | 8 | 17.2 |

2009 | 9 | 18.1 |

(b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, b0 = Slope, b1 = MSE = (c) What is the forecast for year 10? Do not round your interim computations and round your final answer to two decimal places.

Answer #1

b) From the given data

S.No. | t | Enrollment | X^2 | Y^2 | XY |

1 | 1 | 6.5 | 1 | 42.25 | 6.5 |

2 | 2 | 8.1 | 4 | 65.61 | 16.2 |

3 | 3 | 8.4 | 9 | 70.56 | 25.2 |

4 | 4 | 10.2 | 16 | 104.04 | 40.8 |

5 | 5 | 12.5 | 25 | 156.25 | 62.5 |

6 | 6 | 13.3 | 36 | 176.89 | 79.8 |

7 | 7 | 13.7 | 49 | 187.69 | 95.9 |

8 | 8 | 17.2 | 64 | 295.84 | 137.6 |

9 | 9 | 18.1 | 81 | 327.61 | 162.9 |

Total: | 45 | 108 | 285 | 1426.74 | 627.4 |

Intercept: 4.72

Slope: 1.46

Y -hat = 19.28

Year
Number of Alternative-Fueled Vehicles in US
2000
394,664
2001
425,457
2002
471,098
2003
533,999
2004
565,492
2005
592,125
2006
634,562
2007
695,766
Do the variables have significant correlation? For full credit,
you must show each step of the hypothesis test. Use the 0.05
significance.

Year
Number of Alternative-Fueled Vehicles in US
2000
394,664
2001
425,457
2002
471,098
2003
533,999
2004
565,492
2005
592,125
2006
634,562
2007
695,766
Construct a scatter diagram of year (x) vs number of
Alternative-fueled vehicles in US (y). Do these variables appear to
have a relationship? Write 2 or 3 sentences describing the
relationship or lack of a relationship. Explain your reasoning. (9
points for graph and 9 points for description of relationship or
lack of relationship)
2. Description of...

please answe all parts of question 4
Year
Period
Division
Revenue
Number of Customer
2000
1
A
706
333
2000
1
B
151
195
2000
1
C
460
222
2001
1
A
879
252
2001
1
B
619
256
2001
1
C
361
376
2002
1
A
260
519
2002
1
B
302
788
2002
1
C
250
62
2003
1
A
588
67
2003
1
B
862
752
2003
1
C
966
250
2004
2
A
724
638
2004...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 12 minutes ago

asked 18 minutes ago

asked 29 minutes ago

asked 30 minutes ago

asked 46 minutes ago

asked 49 minutes ago

asked 55 minutes ago

asked 57 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago