• Home

Dont Purchase, Click on this file and it will download automatically

Sheet1

Revenue Rank Date Distance (Miles) Revenue
1 3/22/21 1.3 $ 976.00
2 3/14/21 1.3 $ 940.00
3 3/9/21 0.4 $ 916.00
4 3/6/21 3.4 $ 906.00
5 3/30/21 0.9 $ 900.00 SUMMARY OUTPUT
6 3/21/21 1.3 $ 844.00
7 3/2/21 1.2 $ 835.00 Regression Statistics
8 3/8/21 0.4 $ 817.00 Multiple R 0.2706247665
9 3/16/21 0.5 $ 816.00 R Square 0.0732377643
9 3/27/21 1.7 $ 816.00 Adjusted R Square 0.0412804458
11 3/26/21 2.1 $ 811.00 Standard Error 0.9043332937
12 3/11/21 0.8 $ 801.00 Observations 31
13 3/20/21 1.3 $ 782.00
14 3/17/21 0.5 $ 775.00 ANOVA
15 3/28/21 1.7 $ 774.00 df SS MS F Significance F
16 3/19/21 2 $ 765.00 Regression 1 1.8742252629 1.8742252629 2.2917368467 0.1408879558
17 3/1/21 1.2 $ 750.00 Residual 29 23.7167424791 0.8178187062
18 3/13/21 1.7 $ 733.00 Total 30 25.5909677419
18 3/24/21 3 $ 733.00
20 3/5/21 2.6 $ 732.00 Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
21 3/3/21 2.6 $ 694.00 Intercept 2.9574960768 0.8882554375 3.3295558373 0.0023781161 1.1408097263 4.7741824273
22 3/10/21 0.4 $ 688.00 Revenue -0.0017842474 0.001178617 -1.5138483566 0.1408879558 -0.0041947898 0.000626295
23 3/23/21 3 $ 674.00
24 3/29/21 0.9 $ 665.00
25 3/7/21 3.4 $ 632.00
26 3/15/21 2.7 $ 608.00
27 3/18/21 2 $ 590.00
28 3/12/21 0.8 $ 582.00
29 3/31/21 0.9 $ 567.00
30 3/4/21 2.6 $ 558.00
31 3/25/21 2.1 $ 289.00
Total sales 22969
Revenue Distance (Miles)
Mean 740.935483871 1.635483871
Standard Error 25.1602150308 0.1658829998
Median 765 1.3
Mode 733 1.3
Standard Deviation 140.0861486096 0.9235974546
Sample Variance 19624.1290322581 0.8530322581
Kurtosis 2.2479733749 -0.9399766824
Skewness -0.9990638367 0.4071941568
Range 687 3
Minimum 289 0.4
Maximum 976 3.4
Sum 22969 50.7
Count 31 31

Revenue 976 940 916 906 900 844 835 817 816 81 6 811 801 782 775 774 765 750 733 733 732 694 688 674 665 632 608 590 582 567 558 289 1.3 1.3 0.4 3.4 0.9 1.3 1.2 0.4 0.5 1.7 2.1 0.8 1.3 0.5 1.7 2 1.2 1.7 3 2.6 2.6 0.4 3 0.9 3.4 2.7 2 0.8 0.9 2.6 2.1