Reference no: EM132908809
Data Analysis: Survey There are many guides to excel correlation on the internet. A good resource is: https://www.ablebits.com/office-addins-blog/2019/01/23/correlation-excel-coefficient-matrix-graph/#find-correlation-coefficient
BEFORE DOING ANYTHING, DOWNLOAD THE DATA
Fully answer the following questions:
1. Number of people in each gender category
2. What was the range of the self-esteem score totals?
3. What was the average self-esteem score?
4. What was the correlation (using Pearson) of time spent on Instagram and self-esteem total scores?
a. How strong is this correlation (in words)?
5. What was the correlation (using Pearson) of age and time spent on Instagram?
a. How strong is this correlation (in words)?
b. In this correlation, what is the IV and what is the DV?
6. Are there any outliers in the self-esteem total score?
a. If so, which participant and what was the score?
7. make scatterplot of time spent on Instagram and self-esteem total scores. Copy and paste it below: