A business analyst wants to know if a new website design compared to an old website design is showing increased page views per visit. Two different samples of customers are randomly sent to one of two different websites, offering the same products, but with different designs. Is there a difference in average page views between the new and old website design?
Use data from "website" sheet in excel. Run the appropriate statistical test using α=0.01 . Which of the following are true? More than one answer is possible.
There was a significant difference in average page views between new and old designs. |
||
The new design has 44.66 page views higher on average than the old design. |
||
There was no significant difference in average page views between designs. |
||
The new design is not as effective as the old design, based on average number of page views. |
new design | old design |
79 | 109 |
33 | 99 |
78 | 126 |
36 | 104 |
32 | 115 |
95 | 57 |
36 | 71 |
29 | 111 |
14 | 132 |
43 | 90 |
70 | 142 |
72 | 102 |
78 | 61 |
67 | 128 |
44 | 105 |
10 | 147 |
30 | 139 |
67 | 123 |
84 | 141 |
30 | 93 |
65 | 88 |
31 | 50 |
60 | 150 |
34 | 55 |
85 | 64 |
51 | 63 |
45 | 91 |
49 | 143 |
95 | 80 |
30 | 57 |
94 | 117 |
90 | 82 |
84 | 68 |
25 | 91 |
51 | 147 |
39 | 142 |
13 | 84 |
12 | 122 |
54 | 139 |
80 | 100 |
77 | 95 |
12 | 50 |
88 | 81 |
10 | 67 |
96 | 62 |
96 | 92 |
54 | 98 |
94 | 64 |
14 | 83 |
80 | 148 |
There was no significant difference in average page views between designs. |
||
The new design is not as effective as the old design, based on average number of page views. |
As per the statistic output P value < 0.01
t-Test: Paired Two Sample for Means | |||
new design | old design | ||
Mean | 54.7 | 99.36 | |
Variance | 786.9081633 | 945.7453 | |
Observations | 50 | 50 | |
Pearson Correlation | -0.058777523 | ||
Hypothesized Mean Difference | 30 | ||
df | 49 | ||
t Stat | -12.32723121 | ||
P(T<=t) one-tail | 6.23973E-17 | ||
t Critical one-tail | 2.40489176 | ||
P(T<=t) two-tail | 1.24795E-16 | ||
t Critical two-tail | 2.679951974 |
Get Answers For Free
Most questions answered within 1 hours.