MUST USE EXCEL AND WRITE DOWN THE STEPS IN FINDING, AND PASTE THE excel functions, here is the data set, the google spreadsheet link, i dont know how to prepare the two way table

https://docs.google.com/spreadsheets/d/1xYVei7P6GmHNWAIV9T507YBiXjQ07vixNa3iXczdtr8/edit?usp=sharing

1. Refer to the Restaurants dataset. The dataset captures information on EDD restaurants and their quality rating and meal price [in dollars}. Answer the following questions: [Explanation Marginal counts are the totals on the margin {also called marginal distribution}. In a 2way table. you can add up the totals for each row and columns. Those totals are called marginal counts] {e} We wish to use the chisquare test of independence to assess if there is an association between Quality Rating and Meal Price. Use formulas to calculate the expected cell frequencies for each of the cell in your 2way table (you may follow the steps on Page 252253 of your textbook}. {f} Use Excel's CHISQJNVRT [see textbook Page 254} or CHISQTEST to nd the chi square test statistic. {g} Draw your conclusion: Is there an association between Quality Rating and Meal Price among all restaurants? You may use a Decision Point to answer this question (decision point tables for Stat 1181 can be found in STAT 1182's D2L website}. or if you are comfortable interpreting using Pyalue. you may use Excel's chisquare test output to draw a conclusion