Q2. Refer to data set GREEK.EXE A study of local food and authenticity of restaurants in Greece was published in Research in Hospitality Management (Sep., 2019). Nine Greek restaurants participated in the study. Based on interviews with the restaurant managers, two variables were measured (each on a 10-point scale): perceived level of traditionalism and perceived level of adaptation to the guests' tastes. The data are shown in the accompanying table.

1. Graph the data in a scatterplot. What type of trend, if any, do you observe?
2. Based on the graph, is there one restaurant that had a higher than expected level of traditionalism given its perceived level of adaptation? Which one?

Now, the data are analyzed using XLSTAT, as correlation analysis shown below.

1. Locate and interpret the coefficient of determination, on the printout.
2. Locate and interpret the coefficient of correlation, r, on the printout.
3. Conduct a test for linear correlation between perceived level of traditionalism and perceived level of adaptation at Use the p-value reported on the printout.

I need to solve this in EXCEL

Link to the FILE GREEK.xlsx

https://docs.google.com/spreadsheets/d/11IhyTwpE5vdyW_kWG7BSoUQOq_bVcAUW/edit?usp=sharing&ouid=105120223250447954809&rtpof=true&sd=true

AutoSave OFF AAPIG... Home Insert Draw Page Layout Formulas Data R Calibri (Body) v 11 v A A E Paste BIUV A F9 x v fx A B C D E F 1 Restaurant Traditionalism Adaptation N 9 W 2 9 3 Co 5Correlation matrix (Pearson): Variables Tradition Adapt Tradition 1 -0.7490 Adapt -0.7490 1 Values in bold are different from 0 with a significance level alpha=0.05 p-values (Pearson]: Variables Tradition Adapt Tradition 0 0.0202 Adapt 0.0202 0 Coefficients of determination (Pearson): Variables Tradition Adapt Tradition 1 0.5610 Adapt 0.5610 1