Question

please answer using excel and explain

What are the appropriate descriptive statistics to summarize the Company-Z daily sales in Pre- and Post- COVID-19 Y1 & Y2?   Can you visualize both random variables separately using the graphing technique? Explain why you used these descriptive statistics and this graphing technique?               
Given;

Date	Pre-COVID-19		Date	Post-COVID-19
	Y1	X1		Y2	X2
1-Nov-2019	4365.5	7.0	1-Apr-2020	3612.2	11.9
2-Nov-2019	4365.8	7.1	2-Apr-2020	3617.0	8.6
3-Nov-2019	4366.3	7.2	3-Apr-2020	3614.9	7.9
4-Nov-2019	4365.9	7.7	4-Apr-2020	3612.3	11.4
5-Nov-2019	4365.7	7.3	5-Apr-2020	3617.5	8.1

Answer 1

Sales have significantly reduced over time.

Now, descriptives:

For Pre - Covid Time:

Column1
Mean	4365.84
Standard Error	0.132665
Median	4365.8
Standard Deviation	0.296648
Sample Variance	0.088
Kurtosis	1.448864
Skewness	0.884887
Range	0.8
Minimum	4365.5
Maximum	4366.3
Sum	21829.2
Count	5

Average Sales: $4365.8

The distribution says the sale is consistent.

For Y2:

Column1
Mean	3614.78
Standard Error	1.121338
Median	3614.9
Standard Deviation	2.507389
Sample Variance	6.287
Kurtosis	-2.90338
Skewness	-0.03595
Range	5.3
Minimum	3612.2
Maximum	3617.5
Sum	18073.9
Count	5

Average sales = $3615

The distribution is not normal as it represents the random influences of Covid 19

Please rate my answer and comment for doubt.