Problem $10$

Copy the below data set to Excel, and show how you would you organize this survey data for a food product for predictive purposes?

ID

Attribute Type

Attribute Score

Market Share

$231$

Price

$7$

$33\%$

$231$

Packaging

$5$

$33\%$

$231$

Taste

$5$

$33\%$

$231$

Nutrition

$8$

$33\%$

$232$

Price

$6$

$28\%$

$232$

Packaging

$5$

$28\%$

$232$

Taste

$5$

$28\%$

$232$

Nutrition

$7$

$28\%$

$234$

Price

$3$

$15\%$

$234$

Packaging

$5$

$15\%$

$234$

Taste

$5$

$15\%$

$234$

Nutrition

$4$

$15\%$

$235$

Price

$5$

$18\%$

$235$

Packaging

$5$

$18\%$

$235$

Taste

$5$

$18\%$

$235$

Nutrition

$5$

$18\%$

$244$

Price

$5$

$35\%$

$244$

Packaging

$5$

$35\%$

$244$

Taste

$4$

$35\%$

$244$

Nutrition

$9$

$35\%$

$246$

Price

$6$

$22\%$

$246$

Packaging

$5$

$22\%$

$246$

Taste

$7$

$22\%$

$246$

Nutrition

$8$

$22\%\text{'}$