Could you please type in step by step what I need to enter for example: =countif, o:o,"P1"

Data & Statistics (Use the spreadsheet template posted on D2L to answer this problem set; save your Microsoft Excel spreadsheet by your first-last name and assignment number. (e.g. stacey- brook2.xlsx). [50 points]

1. In the Market Share worksheet, calculate the total number of purchases for each brand in cells B2,

   C2, D2 & E2. [countif] makes this easy. Create a Ketchup Market Share Pie chart in this

   worksheet, with the title Ketchup Market Share.

2. In the Display worksheet, calculate the total number of times each brand has been on display in

   cells B2, C2, D2 & E2. [sum] or [countif] makes this easy. Calculate the total number of times that each brand has been on display was actually purchased in cells B3, C3, D3 & E3. [countifs] makes this easy. Calculate the percentage of purchases based on the number of times the product was on display in cells B4, C4, D4 & E4 (i.e. B3/B2, ...). Finally, calculate the correlation between brand display and consumer brand purchase (by brand) in cells B6, C6, D6 & E6.

3. In the Features worksheet, calculate the total number of times each brand has been featured in cells B2, C2, D2 & E2. [sum] or [countif] makes this easy. Calculate the total number of times that each brand has been featured was actually purchased in cells B3, C3, D3 & E3. [countifs] makes this easy. Calculate the percentage of purchases based on the number of times the product was on display in cells B4, C4, D4 & E4 (i.e. B3/B2, ...). Finally, calculate the correlation between brand feature and consumer brand purchase (by brand) in cells B6, C6, D6 & E6.

4. In the Price worksheet, calculate the average price for each brand in cells B2, C2, D2 & E2. Calculate the standard deviation of price for each brand in cells B3, C3, D3 & E3. Calculate the correlation between price whether the brand was purchased for each brand in cells B4, C4, D4 & E4.

   Problem Set 2 continues on the next page

e. In the Brand Loyalty worksheet, calculate for each customer the total number of times each brand has been purchased in cells B2, C2, D2 & E2, then copy cells B2 to E2 and paste to row 301. [countifs] makes this easy. In cells I2 through M2 calculate the number of times each brand has a brand loyal customer (this calculation has been given to you in column G). [countif] makes this easy. Calculate the sum of cells I2 through M2 (it should equal the number of customers). Create a Pie chart of customer brand loyalty from cells I2 through M2