Data analysis – using the SFG questionnaire

Data analysis – using the SFG questionnaire (212-216) and the excel data file (SFG Data File.xlsxPreview the document) – Complete the following: Data Cleaning We are only going to examine respondents who have recently eaten at SFG Find respondents who answered ‘1’ in question X_s4; eliminate all other respondents from the data. Use the following video to set your data up for cleaning https://youtu.be/G8wnynz0w4w (Links to an external site.) After completing the instructions in the video, determine how you should clean the data, conduct the cleaning, and explain how you cleaned the data as well as the result of data cleaning on the data (e.g. elimination of respondents, imputation of data, etc.) Provide Descriptive Sample Statistics Interpret the results and indicate whether or not there should be any concerns regarding the sample to guide you through conducting the statistical analysis (e.g. t-test, ANOVA, chi-squared, regression) in Excel to test the hypotheses below: H1: Pricing, Food Quality, Atmosphere, and Service each have a positive impact on satisfaction of SFG customers H2: Females will be more satisfied, more likely to return, and will recommend SFG more than males. H3: Price is more important than Food Quality, Atmosphere, and Service when selecting a restaurant. After conducting the correct statistical test, interpret and report the results What recommendations would you make based on the findings What other statistical insights might you be interested to determine from the data? Indicate any limitations of this research and what you would suggest for future research Please upload your Excel sheet along with your final write-up.

PFA, Data analysis – using the SFG questionnaire (212-216) and the excel data file After completing the instructions in the video, determine how you should clean the data, conduct the cleaning, and explain how you cleaned the data as well as the result of data cleaning on the data (e.g. elimination of respondents, imputation of data, etc.) Provide Descriptive Sample Statistics Use the following videos to conduct descriptive statistics regarding your sample: SFG Analysis Use this video (Data Analysis 3 – Inferential.mp4 Play media comment.) to guide you through conducting the statistical analysis (e.g. t-test, ANOVA, chi-squared, regression) in Excel to test the hypotheses below: H1: Pricing, Food Quality, Atmosphere, and Service each have a positive impact on satisfaction of SFG customers H2: Females will be more satisfied, more likely to return, and will recommend SFG more than males. H3: Price is more important than Food Quality, Atmosphere, and Service when selecting a restaurant. After conducting the correct statistical test, interpret and report the results What recommendations would you make based on the findings What other statistical insights might you be interested to determine from the data?