Chapter 1.2, Problem 53E

B. Present the following data in Tabular Form. Stat Mountain Bike Shop has sold 50 bicycles the month of January. Similarly, in the month of February 60 bicycles were sold. While in March the sales go down to 45 and 30 in May.

The average monthly residential gas bill for Black Hills Energy customers in Cheyenne, Wyoming is  (Wyoming Public Service Commission website). How is the average monthly gas bill for a Cheyenne residence related to the square footage, number of rooms, and age of the residence? The following data show the average monthly gas bill for last year, square footage, number of rooms, and age for  typical Cheyenne residences.   Average Monthly Gas     Number of Bill for Last Year Age Square Footage Rooms $70.20 16   2537   6   $81.33 2   3437   8   $45.86 27   976   6   $59.21 11   1713   7   $117.88 16   3979   11   $57.78 2   1328   7   $47.01 27   1251   6   $52.89 4   827   5   $32.90 12   645   4   $67.04 29   2849   5   $76.76 1   2392   7   $60.40 26   900   5   $44.07 14   1386   5   $26.68 20   1299   4   $62.70 17   1441   6   $45.37 13   562   4   $38.09 10   2140   4   $45.31 22   908   6   $52.45 24   1568   5   $96.11 27   1140   10…

I need assistance with parts a, b, and c.  Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrollment (in thousands) for Jefferson Community College for the nine most recent years. Click on the datafile logo to reference the data. 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 A. Choose the correct time series plot. What type of pattern exists in the data? Positive trend pattern or negative trend pattern 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.