Scribd
Upload
59 views6 pages

Sale of Packaged Milk in 36 Months: Regression Statistics

1. The document shows monthly sales of packaged milk over 36 months, ranging from $6,337,111 to $11,038,170. 2. A linear regression analysis found a moderate positive correlation (R^2 = 0.2032) between month and sales, with the regression equation: f(x) = 56952.85x + 7361865. 3. The regression analysis was statistically significant (p = 0.0065) with the sales amount increasing an average of around $57,000 per month.

Uploaded by

himanshu sagar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
59 views6 pages

Sale of Packaged Milk in 36 Months: Regression Statistics

1. The document shows monthly sales of packaged milk over 36 months, ranging from $6,337,111 to $11,038,170. 2. A linear regression analysis found a moderate positive correlation (R^2 = 0.2032) between month and sales, with the regression equation: f(x) = 56952.85x + 7361865. 3. The regression analysis was statistically significant (p = 0.0065) with the sales amount increasing an average of around $57,000 per month.

Uploaded by

himanshu sagar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Month Sales

April 1 6436977
May 2 8038673
June 3 7699105
July 4 7446966
August 5 6893954
September 6 7266777
October 7 9577732
November 8 6959258 Sale of Packaged Mi
December 9 9196648 12000000
January 10 7703373
February 11 6337111 10000000
March 12 6661873 f(x) = 61928.3990990991x + 7361865.03333333
8000000 R = 0.24269199
April 13 8168753
May 14 9042377 6000000
June 15 8535593
July 16 9159860 4000000
August 17 8660746
2000000
September 18 7985469
October 19 10287574 0
November 20 8865297 0 5 10 15 20 25 30
December 21 10106207
January 22 8763792
February 23 6573767
March 24 7012498
April 25 8727300 SUMMARY OUTPUT
May 26 9936678
June 27 9777312 Regression Statistics
July 28 10408932 Multiple R 0.4507936826
August 29 9666011 R Square 0.2032149443
September 30 8922312 Adjusted R Square 0.1790699426
October 31 11038170 Standard Error 1172965.93469856
November 32 9234684 Observations 35
December 33 10751284
January 34 9737546 ANOVA
February 35 7068566 df
March 36 7622280 Regression 1
Residual 33
Total 34

Coefficients
Intercept 7484595.1442577
1 56952.8540616246
Sale of Packaged Milk in 36 Months

x + 7361865.03333333
Sale of Packaged Milk in 36 Months
Linear (Sale of Packaged Milk in 36 Months)

15 20 25 30 35 40

SS MS F Significance F
11579750481180 11579750481180 8.4164394309 0.0065731445
45403019770788.1 1375849083963.3
56982770251968.2

Standard Error t Stat P-value Lower 95% Upper 95%


422417.388165934 17.718482605 1.99981155E-18 6625180.510446 8344009.77806944
19631.4008738507 2.9011100343 0.0065731445 17012.468874204 96893.2392490456
hs
36 Months)

Lower 95.0% Upper 95.0%


6625180.510446 8344009.77806944
17012.4688742 96893.2392490456

You might also like