Do exploratory analysis of the sample transaction data to determine what is true about the average daily profit.

• Use the Task 1 worksheet as your work area.
• Note - you will need to complete the Weekday column on the Transaction worksheet before creating your PivotTable.
• Select your answer from the drop down in cell B3.

Which four brands, based on the quantity sold, are the top performers at Carey's Extreme Sports?

• Use the Task 2 worksheet as your work area.
• The PivotTable should show only the top 4 brands.
• Sort the PivotTable to show the quantities in descending order.
• Select your answer from the drop down in cell B3.

What is the cumulative profit generated from the four highest-selling brands at Carey's Extreme Sports, based on quantity sold?

• Use the Task 3-4 worksheet as your work area.
• Sort the PivotTable to show the profit in descending order.
• Select your answer from the drop down in cell B3.

Having identified the top four lucrative brands found in 1.3, you aim to present your findings visually to your manager. To accomplish this, create a column chart with no legend and provide a meaningful title to convey your results effectively.

• Place your column chart on the "Task 3-4" worksheet with the top left corner of the chart in cell B13.

What would be the null hypothesis of the population# if you intend to investigate whether profit can be predicted based on Customers' Age and Customers' Ratings of the product sold?

• Select your answer from the drop down in cell B3.

Using your hypothesis from task 1.5, which statement is true about the results obtained from your analysis?

• Copy and paste the columns needed to the Task 5-6 worksheet to the right of the yellow field beginning in cell Q3.
• You can do as many models as you need.
• Place your final model (regression analysis output with ONLY significant variables remaining) beginning in cell E3.
• There should be ONLY one model on the Task 5-6 worksheet.
• Select your answer to the question from the drop down in cell B6.

Following your discussion with the operation managers, you became intrigued about the potential profitability of different time intervals during the day. After analyzing the sample data, which time interval demonstrates the highest level of profitability?

• Use the Task 7 worksheet as your work area and select your answer from the drop down in cell B3.
• Hint - create a chart from the PivotTable data to help you visualize the answer to the question.

Your objective is to create a profit prediction model that considers Customers' Ratings and Customers' Age. Develop this model specifically for the top four brands, based on quantity sold, and determine which of the following statements accurately describes your final model (the regression analysis output with ONLY significant variables remaining).

• Filter the transaction data after identifying the top four brands, based on quantity sold.
• Copy and paste the columns needed to the Task 8-9 worksheet to the right of the yellow field beginning in cell Q3.
• You can do as many models as you need.
• Place your final model (regression analysis output with ONLY significant variables remaining) beginning in cell E3.
• There should be ONLY one model on the Task 8-9 worksheet.
• Select your answer to the question from the drop down in cell B6

In the final model (with only significant independent variables remaining) you created for 1.8, which of the following statements is correct in regards to the parameter estimates (beta coefficients).

• Select your answer from the drop down in cell B6.

At the request of the operations manager, you were tasked with examining the customer ratings for specific product categories within the top four brands to enhance profitability assessment. To achieve this, you opted to construct a model that utilizes Customer Age and Customer Rating to determine profitability, focusing solely on the two most popular product categories within the top four brands. Note: The product popularity is measured by the quantity sold.

• Filter the transaction data after identifying the two most popular product categories.
• Copy and paste the columns needed to the Task 10 worksheet to the right of the yellow field beginning in cell Q3.
• You can do as many models as you need.
• Place your final model (with only significant independent variables remaining) beginning in cell E3.
• There should be ONLY one model on the Task 10 worksheet.
• Select your answer to the question from the drop down in cell B3.