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. also, make sure that the Analysis ToolPak Add-in is installed in your Excel program. Review Load the Analysis ToolPak in Excel (Links to an external site.) article to learn more.
undefined
Raw data for analysis | ||||
Subject # | Age | Gender | Exercise Motivation | Exercise Motivation |
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 |
undefined
Analyze the Data
undefined
Task 1: Frequency Table
undefined
With all data, create a frequency table (Counts, Relative Frequency, and Percent). Review the video tutorial below if you need help:
undefined
Task 2: Descriptive Statistics
undefined
With ordinal and continuous data, run descriptive statistics, showing Mean, Median, Mode, Standard deviation, etc. Review the video tutorial below if you need help:
undefined
Task 3: Correlation Analyses
undefined
Run correlation analyses between paratelic and telic exercise motivation scores. Review the video tutorial below if you need help:
undefined
undefined
Task 4: P-value
undefined
Obtain P-value for the correlation coefficient r. Review the video tutorial below if you need help:
undefined
undefined
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.
undefined
Criteria | Ratings | Pts |
This criterion is linked to a Learning Outcome Excel data file with your completed analysis | 70 pts | |
This criterion is linked to a Learning OutcomeOne paragraph narrative summarizing analysis completed and your interpretation of results | 20 pts | |
This criterion is linked to a Learning OutcomeA statement as to how you contributed to this assignment (if completed in pairs) | 10 pts |
Expert Solution Preview
Introduction:
The following tasks are designed to analyze raw data on exercise motivation of 11 subjects using Excel and statistical analysis tools. The data includes two variables- paratelic and telic motivation scores.
Task 1: Frequency Table
To create a frequency table, we used the COUNTIF function in Excel to count the number of occurrences of different scores for paratelic and telic motivation. The relative frequency and percent frequency were calculated by dividing the count by the total number of scores.
Task 2: Descriptive Statistics
For both paratelic and telic scores, descriptive statistics were calculated using Excel’s Analysis ToolPak. The mean, median, mode, standard deviation, range, and quartiles were obtained. For paratelic scores, the mean value was 13.21, with a standard deviation of 8.92. For telic scores, the mean value was 19.73, with a standard deviation of 8.02.
Task 3: Correlation Analyses
A correlation analysis was conducted between paratelic and telic scores. The Pearson correlation coefficient was 0.028, indicating a weak positive correlation between the two variables. This suggests that individuals with high paratelic motivation scores may also have high telic motivation scores.
Task 4: P-value
The p-value for the correlation coefficient was found to be 0.924, which is greater than the standard significance level of 0.05. Therefore, we fail to reject the null hypothesis that there is no significant correlation between paratelic and telic scores.
In summary, the statistical analysis of the exercise motivation data reveals a weak positive correlation between paratelic and telic scores. This suggests that individuals may have both spontaneous and goal-oriented motives for exercising. However, further research is needed to confirm this relationship.
