Case: Dominguez Cheese Website Traffic

Website transactions are an important segment of sales and distribution today. Dominguez Cheese manufactures and sells quality cheeses at its plant and retail store in Carson, CA. Two years ago, the company developed a website and began sales on the internet. Website sales have exceeded expectations, and management is now considering strategies to continue to increase its sales. To learn more about its sales, Dominguez Cheese selected a sample of 50 random transactions from its previous month's sales. The transaction data shows the day of the week the purchase was made, the type of browser used in the transaction, the time spent on the website, the number of website pages viewed, and the amount spent by the customer. The data is shown in a file namedCheese.

Dominguez Cheese 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.

Managerial Report

Provide a explanation using ANOVA and regression models to learn how each categorical variable and continuous variables, respectively, contribute to the sales of cheese.

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

File Home Insert Page Layout Formulas Data Review View Help Cut Times New Roman - 12 AA 29 Wrap Text General In Copy Merge & Center Format Painter Clipboard For Alignment Nur EZ A C D E F G 1 Customer Day Browser Time (min) Pages Viewed Amount Spent (S) Mon Internet Explorer 12.0 4 54.52 Wed Other 19.5 94.90 Mon Internet Explorer 8.5 26.68 Tuc Firefox 11.4 2 44.73 Wed Internet Explorer 11.3 66.27 G Sat Firefox 10.5 67.80 Sun Internet Explorer 11.4 36.04 Fri Firefox 1.3 $5.96 10 Wed Firefox 12.7 70.94 11 10 Tuc Internet Explorer 24.7 68.73 12 11 Sat Other 13.3 6 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 Fri Internet Explorer 8.4 3 84.12 17 16 Thu Internet Explorer 9.6 4 39.20 18 17 Thu Internet Explorer 23.3 7 91.62 19 18 Mon Internet Explorer 14.0 126.40 20 19 Fri Other 5.6 68.45 21 20 Wed Internet Explorer 15.1 32.69 22 21 Sat Firefox 16.3 78.58 23 22 THE Internet Explorer 10.2 74.43 24 23 Sum Internet Explorer 8.0 3 32.73 25 24 The Firefox 8.0 2 48.66 26 25 Fri Firefox 9.6 54.56 27 26 Wed Internet Explorer 11.0 40.54 28 27 Sat Internet Explorer 16.9 34.69 29 28 Firefox 6.0 27.91 29 Fri Firefox 32.9 10 155.30 30 Mon Other 11.6 120.25 32 31 Thu Internet Explorer 7.1 41.20 32 Fri Firefox 18.0 134.40 33 Sun Internet Explorer 11.8 37.17 35 34 Fri Internet Explorer 9.1 52.09 36 35 Tue Internet Explorer 71.81 Mon Firefox 16.5 59.99 37 Firefox 6.2 84.17 Bat Internet Explorer 11.3 35.48 39 The Internet Explorer 10.6 39.06Cheese - Last Modified: 1h ago = AutoSave On File Home Insert Page Layout Formulas Data Review View Help X. Cut Times New Roman - 12 AA 25 Wrap Text IF Copy Paste Merge & Center Format Painter Clipboard Font Alignment E2 X y 4 B C D F G 400 39 Tue Internet Explorer 10.6 39.06 41 40 Wed Internet Explorer 5.0 36.48 42 41 Tue Other 15.9 4 67.44 43 42 Sat Internet Explorer 18.1 60.14 43 Fri Firefox 10.8 70.38 45 44 Mon Internet Explorer 13.3 7 110.65 46 45 Mon Internet Explorer 30.1 G 104.23 17 46 Fri Firefox 13.7 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 52.15 51 50 Fri Internet Explorer 13.4 98.75 52 53 54 55 56 57 58 59 60 61 62 63 65 66 67 69 71 72 73 74 75