The health psychologist in question is particularly interested in the

The health psychologist in question is particularly interested in the myth of the “Freshmen 15.” This myth claims that most freshmen gain weight during the first year of college, mostly due to bad eating habits and lack of exercise and sleep. He wonders if the Freshmen on his campus actually exercise less than the general population of college students. He randomly selects a sample of 50 Freshmen students and asks them how many minutes they exercise per week. The raw data collected by the health psychologist are in this module/week’s Data Set, entitled “Data Set 5”.
Part 1: Confidence Interval
1. Open the Excel file entitled “Data Set 5”. The file contains the following: a) raw data for the sample of 50 Freshmen; b) a results table for Part 1; c) Questions for Part 1; d) a results table for Part 2; and e) Questions for Part 2.

2. Construct a 95% Confidence Interval of the population mean of minutes exercised per week.
a. First, fill in cells with information given in the research question above (N and sigma). (4 pts)
b. In the appropriate cell in the table, compute the sample mean using the raw data given in column A. (Use the AVERAGE function.) (4 pts)
c. Determine the alpha level for this problem and type it in the appropriate cell. (4 pts)
d. As seen in this module/week’s presentation, use the CONFIDENCE function to compute the 95% confidence interval in the appropriate cell in the table. (4 pts)
e. Again as seen in the presentation, compute the lower and upper limits of the confidence interval in the appropriate cells.(4 pts)

3. Answer all five questions beneath the first table. Type answers directly into the Excel file as indicated. (Questions = 3 points each for total of 15 pts.)

Part 2: Hypothesis Test
1. State the null and alternative (research) hypothesis in symbolic form. The hypothesis should be written based on the following information from the research situation: “The health psychologist in question is particularly interested in the myth of the ‘Freshmen 15.’ This myth claims that most freshmen gain weight during the first year of college, mostly due to bad eating habits and lack of exercise and sleep. He wonders if the Freshmen on his campus actually exercise less than the general population of college students (which has a μ = 100 and σ = 25).” (Remember that your hypothesis should include evaluators such as =, [removed] or a combination of these.) (2 pts)

2. Is your hypothesis directional or non-directional? Read the wording again in question 1 if you are unsure. The evaluators (=, [removed], etc.) you used in stating the hypotheses in question 1. above should also give you a clue. Fill in the cell with either “one-tailed” or “two-tailed” based on whether the alternative hypothesis is directional or not. Also, if you fill in “one-tailed”, answer the question to the right of the table concerning the direction of the tail. This decision will help you determine the critical values of your test statistics later, so think carefully! (2 pts)

3. Fill in the cells for N, μ, and σ which are already known. These will be used in formulas as shown in this week’s presentation. (2 pts)

4. In the appropriate cell in the table, compute the Standard Error of the Mean (σM) using the steps shown in this week’s presentation. (2 pts)

5. Fill in the sample mean (M), again using the AVERAGE function. (2 pts)

6. We are going to test our hypothesis at the .05 level of significance. Enter the alpha value in the appropriate cell. (2 pts)

7. Find the critical Z value for our test, based on the alpha level, using the NORMSINV function as shown in this module/week’s presentation. Remember to consider the direction(s) of your hypothesis when computing this Z value! (2 pts)

8. Compute the sample Z score using the steps gone over in this module/week’s presentation. (2 pts)

9. Fill in the critical p-value based on your alpha level. (2 pts)

10. Compute your sample’s p-value (based on your sample’s Z score) by using the NORMSDIST function as shown in this week’s presentation. (2 pts)

11. Answer all five questions underneath the second table directly in Data Set 5, after each question as indicated. (Questions = 3 points each for total of 15 pts.)

S







Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10