Below is some raw data on 11 subjects that I want you to use and enter first into an Excel file. Then, complete the required statistical analyses. Exercise motivation is divided into two types (variables): paratelic and telic. Paratelic motivation refers to motives for exercising that people feel are spontaneous, exciting, and fun. Telic motivation refers to motives for exercising that are serious and strategies for goal setting and planning.
Subject # Age Gender Exercise Motivation
Paratelic Score Exercise Motivation
Telic Score
1000 26 F 26 10
1001 40 F 10 25
1002 58 M 8 22
1003 30 M 15 9
1004 38 M 10 22
1005 49 F 5 30
1006 21 F 22 9
1007 33 F 12 28
1008 60 M 30 5
1009 45 M 15 30
1010 35 M 5 24
1. With all data, create a frequency table (Counts, Relative Frequency, and Percent).
2. With ordinal and continuous data, run descriptive statistics, showing Mean, Median, Mode, Standard deviation
3. Run correlation analyses between paratelic and telic exercise motivation scores.
4. Obtain P-value for the correlation coefficient r
Note: Unlike the simple correlation coefficient r, which tells both the strength and direction of the association between two variables, Multiple R tells only the strength of the association and is never a negative value. So, report the simple correlation coefficient r value (rather than Multiple R value) and p-value.
Also, make sure that the Analysis ToolPak Add-in is installed in your Excel program.
NOTE:
Excel data file with your completed analysis (70 points)
One paragraph narrative summarizing analysis completed and your interpretation of results (20 points)
Below are helpful links: