Website transactions are an important segment of sales and distribution today.DominguezCheesemanufactures and sells qualitycheesesat its plant and retail store inCarson,CA.Twoyears 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,DominguezCheeseselected 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.
DominguezCheesewould 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.
Prepare a reportusing ANOVAand regression modelsto learn howeach categoricalvariableand continuous variables, respectively,contribute to the sales ofcheese.
You needtodevelop hypothesis, conduct the analysis on Excel,interpret results,develop final conclusions and recommendations for decision-making.