Starstruck candy would like to determine if time spent on the website or the number of pages viewed influences the total purchase. They would also like to examine any effect that day of the week and browser type have on sales.

Using ANOVA and regression models, gather info on each categorical variable and continuous variables, respectively, contribute to the sales of candy.

Develop hypothesis, conduct the analysis on Excel,interpret results, develop final conclusions and recommendations for decision-making.

Customer Day Browser Time (min) Pages Viewed Amount Spent ($) Mon Internet Explorer 12.0 4 54.52 Wed Other 19.5 6 94.90 Mon Internet Explorer 8.5 26.68 Tue Firefox 11.4 2 44.73 JaUAWN Wed Internet Explorer 11.3 4 66.27 Sat Firefox 10.5 67.80 Sun Internet Explorer 11.4 36.04 Fri Firefox 4.3 55.96 9 Wed Firefox 12.7 70.94 Ju ajwaNa 11 10 Tue Internet Explorer 24.7 68.73 11 Sat Other 13.3 54.04 13 12 Sun Firefox 14.3 48.05 14 13 Sun Other 11.7 64.16 15 14 Mon Firefox 24.4 10 158.51 16 15 Fri Internet Explorer 8.4 3 84.12 17 16 Thu Internet Explorer 9.6 59.20 18 17 Thu Internet Explorer 23.3 91.62 19 18 Mon Internet Explorer 14.0 7 126.40 20 19 Fri Other 5.6 4 68.45 21 20 Wed Internet Explorer 15.1 5 32.69 22 21 Sat Firefox 16.3 5 78.58 23 22 Tue Internet Explorer 10.2 74.43 24 23 Sun Internet Explorer 8.0 32.73 25 24 Tue Firefox 8.0 48.66 26 25 Fri Firefox 9.6 54.66 A UI N W N WC 27 26 Wed Internet Explorer 11.0 40.54 28 27 Sat Internet Explorer 16.9 34.69 29 28 Sat Firefox 5.0 27.91 30 29 Fri Firefox 32.9 10 155.30 31 30 Mon Other 11.8 9 120.25 32 31 Thu Internet Explorer 7.1 2 41.20 33 32 Fri Firefox 18.0 8 134.40 34 33 Sun Internet Explorer 11.8 4 37.17 35 34 Fri Internet Explorer 9.1 52.09 36 35 Tue Internet Explorer 7.8 71.81 AUUI W 37 36 Mon Firefox 16.5 59.99 38 37 Thu Firefox 6.2 84.17 39 38 Sat Internet Explorer 11.3 4 55.58 40 39 Tue Internet Explorer 10.6 39.06 41 40 Wed Internet Explorer 5.0 36.48 42 41 Tue Other 15.9 67.44 JAJAUN 43 42 Sat Internet Explorer 18.1 60.14 44 43 Fri Firefox 10.8 70.38 45 44 Mon Internet Explorer 13.3 110.65 46 45 Mon Internet Explorer 30.1 6 104.23 47 46 Fri Firefox 13.7 4 68.17 48 47 Thu Internet Explorer 8.1 17.84 49 48 Fri Internet Explorer 9.7 103.15 50 49 Mon Other 7.3 6 52.15 51 50 Fri Internet Explorer 13.4 w 98.75