Please use excel and write down the steps in the excel functions:

The data set is in the google spreadsheets here:

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

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 from observation of what the child ate each day.

(a) Draw a scatterplot for these data

(b) What does the scatterplot indicate about the relationship between time and calories?

(c) Calculate the sample correlation coefficient r using the formula given. Work must be shown on Excel

\f