Question

The manager of a store would like to know if the average daily sales (measured in dollars) through her website are any different than her in-store sales. The data has been collected on 51 days on website and in store. Perform an analysis at 5% significance level. Start by stating the hypothesis.

Online	In-Store
805.45	1400.76
780.27	969.27
927.79	1049.61
812.86	1453.6
550.91	876.72
901.07	1119.49
869.76	976.6
867.17	1017.76
801.91	482.12
973.15	1149.21
746.65	809.37
980.25	968.43
892.53	1077.45
871.39	1166.04
970.98	582.81
641.09	766.93
1051.25	955.73
809.82	562.64
721.97	786.01
798.97	1369.56
983.14	1219.63
1124.83	556.64
801.21	678.46
932.67	370.61
724.8	587.05
894.94	1203.42
1017.18	555.95
876.98	1104.13
961.01	722.83
930.66	1082.07
882.56	840.62
853.19	823.12
983.99	792.55
1016.78	619.14
858.44	1212.75
748.53	1423.27
742.14	1155.01
916.54	753.26
1008.92	1066.35
785.11	1087.33
962.46	1018.6
818.67	907.18
849.03	1283.63
552.5	1319.92
728.71	530.62
747.62	710.89
1194.59	1150.54
586.63	946.98
916.22	1358.48
1025.76	1589.44
877.63	1165.92
835.7	1035.52

Answer 1

Run a regression analysis in excel followed by below procedures:

1. Go to data tab --> data analysis --> choose Regression

Summary result:

Significance F is nothing but P-value.

P-value = 0.94 is higher than the 0.05 significance level

If the p-value is NOT less than the significance level (α=0.05)

• Decision: DO NOT REJECT the null hypothesis.
• Conclusion: "There is insufficient evidence to conclude that there is a significant linear relationship between x and y because the correlation coefficient is NOT significantly different from zero."