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
Discount Assign
Activity-3_Data1111.xlsx
