The correlation (sample correlation coefficient) / is defined by the following equation: r n E (Refer to a textbook if you are not certain of these...

MUST USE EXCEL AND WRITE DOWN THE STEPS IN FINDING, AND PASTE THE excel functions

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

1. The correlation (sample correlation coefficient) / is defined by the following equation:rnE(Refer to a textbook if you are not certain of these symbols)Refer to the dataset lunchtime.The dataset provides data on 20 children observed over several months at a nursery school.Time is the average number of minutes a child spent at the table when lunch is served.Calories is the average number of calories the child consumed during lunch, calculated fromobservation of what the child ate each day.(c) Calculate the sample correlation coefficient r using the formula given above. Your workmust be shown on an Excel spreadsheet.(d) Use the CORREL function to validate your answer in part (c).