Homework Assignment $1($adapted from Case Study $1$ of Chapter $4,$ Business Analytics$)$:

Follow the prompts below and record your answers on Canvas. The data on the "boise" and "knoxville" worksheets contains ratings from customers on various attributes for Crispy Spuds chips. Higher ratings indicate higher values for each category, where higher is better. The age of the respondents and whether they regularly consume the product are also given.

Combine the tables from the "boise" and "knoxville" worksheets, by creating a new column for "Location" that contains either "boise" or "knoxville". Create a column under $"$ID$"$ which combines the "Location" and "Respondent" columns with an $"\_"$ as a delimeter $($e$.$g$.$ "Boise$\_1").$ You can copy and paste the data from the two worksheets into the "Answers" worksheet.

Delete the duplicate records from the table and record the number of originally duplicate records.

Count the missing values from each column.

Generate a new field called "Taste" as the mean of the Crispiness, Saltiness, Sweetness, Flavor, and Texture columns. Show only one decimal place.

Create a pivot table which displays the average of the "Taste" column, by "Location" and "Regularly Consume Cripsy Spuds?", and the relative frequency of customers in each category based on ID $($use the count$).$ The relative frequency should be a $\%$ of the parent row total. There should be a row for each Location and Regularly Consume Crispy Spuds? Answer.

Create a Histogram for the "Taste" column and calculate the mean and median of that column. send me an excel file pictures please