Dont Purchase, Click On This File And It Will Download Automatically
Discount Assign
StatisticsUsingExcel11.docxRunning head: STATISTICS 1
STATISTICS 3
Statistics Using Excel
Name
Institution
Course
Tutor
Based on the data, please answer the following.
1. What were the best days of the month for sales? (Top 5)
22/03/2021, 14/03/2021, 09/03/2021, 06/03/2021, 30/03/2021
2. What days of week are the best for sales?
The end of the week records the best sales.
3. What was the total sales for the month?
$ 22,969.00
4. What days were the worst for sale? (Lowest 5)
15/03/2021, 18/03/2021, 12/03/2021, 31/03/2021, 04/03/2021, 25/03/2021
5. Rank the weeks by best sales from greatest to least: 1, 2, 3, or 4. Hint: total the week’s sales and group accordingly. Omit the 29-31 in your ranking.
|
Revenue Rank |
Date |
Revenue |
Distance (Miles) |
|
1 |
22/03/2021 |
$ 976.00 |
1.3 |
|
2 |
14/03/2021 |
$ 940.00 |
1.3 |
|
3 |
09/03/2021 |
$ 916.00 |
0.4 |
|
4 |
06/03/2021 |
$ 906.00 |
3.4 |
|
5 |
30/03/2021 |
$ 900.00 |
0.9 |
|
6 |
21/03/2021 |
$ 844.00 |
1.3 |
|
7 |
02/03/2021 |
$ 835.00 |
1.2 |
|
8 |
08/03/2021 |
$ 817.00 |
0.4 |
|
9 |
16/03/2021 |
$ 816.00 |
0.5 |
|
9 |
27/03/2021 |
$ 816.00 |
1.7 |
|
11 |
26/03/2021 |
$ 811.00 |
2.1 |
|
12 |
11/03/2021 |
$ 801.00 |
0.8 |
|
13 |
20/03/2021 |
$ 782.00 |
1.3 |
|
14 |
17/03/2021 |
$ 775.00 |
0.5 |
|
15 |
28/03/2021 |
$ 774.00 |
1.7 |
|
16 |
19/03/2021 |
$ 765.00 |
2 |
|
17 |
01/03/2021 |
$ 750.00 |
1.2 |
|
18 |
13/03/2021 |
$ 733.00 |
1.7 |
|
18 |
24/03/2021 |
$ 733.00 |
3 |
|
20 |
05/03/2021 |
$ 732.00 |
2.6 |
|
21 |
03/03/2021 |
$ 694.00 |
2.6 |
|
22 |
10/03/2021 |
$ 688.00 |
0.4 |
|
23 |
23/03/2021 |
$ 674.00 |
3 |
|
24 |
29/03/2021 |
$ 665.00 |
0.9 |
|
25 |
07/03/2021 |
$ 632.00 |
3.4 |
|
26 |
15/03/2021 |
$ 608.00 |
2.7 |
|
27 |
18/03/2021 |
$ 590.00 |
2 |
|
28 |
12/03/2021 |
$ 582.00 |
0.8 |
6. What is the average for the month?
$ 740.94 for the Sales, and 1.6355 Miles for the distance
7. What is the mode?
$816 Sales and 1.3 Miles
8. What is the range in sales?
$ 687
9. Run a regression and use the data to create a graph in Excel.
|
SUMMARY OUTPUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Regression Statistics |
|
|
|
|
|
|
|
Multiple R |
0.270624767 |
|
|
|
|
|
|
R Square |
0.073237764 |
|
|
|
|
|
|
Adjusted R Square |
0.041280446 |
|
|
|
|
|
|
Standard Error |
0.904333294 |
|
|
|
|
|
|
Observations |
31 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
|
Regression |
1 |
1.874225263 |
1.874225263 |
2.291736847 |
0.140887956 |
|
|
Residual |
29 |
23.71674248 |
0.817818706 |
|
|
|
|
Total |
30 |
25.59096774 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
|
Intercept |
2.957496077 |
0.888255437 |
3.329555837 |
0.002378116 |
1.140809726 |
4.774182427 |
|
Revenue |
-0.001784247 |
0.001178617 |
-1.513848357 |
0.140887956 |
-0.00419479 |
0.000626295 |
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
Revenue
Distance (Miles)
