Allen County Community College Data Analysis Frequency Table Worksheet
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: https://youtu.be/fPt5apTEQew
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: https://youtu.be/Czgl_VZH370
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 |
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp
Order Paper Now
