The following questions require that you access Microsoft Excel ® The data set for this assignment is located in the Pulse Rate Dataset.
1. John is interested in determining if frequency of exercise affects pulse rate. John randomly samples individuals at a local gym to ask if they will participate in his study. 55 individuals agree, and they are divided into three groups of exercisers: 1 = high frequency, 2 = moderate frequency, 3 = low frequency. Next, John measures their pulse after their workout. Do pulse rates differ among individuals who exercise with high frequency versus those who exercise moderately versus those who exercise with low frequency? Note: Make sure you adjust the data so that there are three exercise variables (one for each level). Conduct a one-way ANOVA to investigate the relationship between exercise frequency (Exercise) and pulse rate (Pulse1). Conduct Tukey's HSD post hoc tests, if necessary. On the output, identify the following: here is the information Variable Description Height Height (cm) Weight Weight (kg) Age Age (years) Gender Sex (1 = male, 2 = female) Smokes Regular smoker? (1 = yes, 2 = no) Alcohol Regular drinker? (1 = yes, 2 = no) Exercise Frequency of exercise (1 = high, 2 = moderate, 3 = low) Ran Whether the student ran or sat between the first and second pulse measurements (1 = ran, 2 = sat) Pulse1 First pulse measurement (rate per minute) Pulse2 Second pulse measurement (rate per minute)
Help needed From the above information ''how can I do P value for exercise effect for pulse 1 in excel'' Please any explanation in how I can calculate the p-value in excel.
Questions & Answers
Have a Question?
Be the first to ask a question about this.