Excel Assignment

The t-test Assignment

 

Don't use plagiarized sources. Get Your Custom Essay on
Excel Assignment
Just from $13/Page
Order Essay

Make sure to show all your work!

This was a study performed to determine if 6 weeks of Cross-Training OR 6 weeks of Running will result in a greater weight loss (lbs). 80 people were recruited and put either into the ‘Cross-Training’ or ‘Running’ group (so 40different people in each group). Both groups had their weight (lbs)measured before and after the 6-week exercise protocol (Cross-TrainingOR Running). The amount weight lostwas calculated and used as the dependent variable. It was not sure which exercise group would on average lose more weight!

 

  • In column B, count from 1 to 40 – remember this is just a count! (2)
  • In column C, have a set of random values (Cross-Training) (4)
    1. use the =randbetween command and have a range from 11 to 17

 

  • In column D convert column C functions to values (4)
    1. This will be your first set of data that you will use for the t-test
  • In column E, have a set of random values (Running) (4)
    1. use the =randbetween command and have a range from 16 to 26
  • Convert the column E functions to values (in column F) (4)
    1. This will be your second set of data that you will use for the t-test

  • Calculate the mean and SD for each group (4)
  • Perform the proper t-test (20)
    1. Based on the SD values for each group
    2. Whether your study is ‘between subject’ or ‘within subject’
    3. Explain whether your test showed a significant difference or not using the example shown in lecture for both the generic and t-test specific methods for determining significance. Make sure to include the values in your explanation.
    4. Explain the outcome of the t-test – meaning, in 7c. you explain if the test showed significance or not, but what does that mean in terms of a t-test and what SPECIFICALLY is being studied here!
    5. Make sure to highlight the one-tailed OR two-tailed t-test information that you used to determine significance.

  • Develop a VERTICAL bar (column) graph with the means of both groups in it (20)
    1. In other words, your graph will only have a TOTAL of 2 bars (one for each group’s average).I should NOT see more than 2 bars on your graph!!!
    2. Make sure to include properstandard deviation bars as taught in the lectures.
    3. Have proper title with units for the Y axis and proper X axis titles (the groups’ name). DO NOT have a main title on your graph and do not have a legend.
  • Neatness!! (10)
    1. You will be getting marks for neatness
    2. Include labels in each of your columns, so I know what’s what!
    3. Show equations throughout your assignment
    4. Use proper labels and units for headings & on the figure
    5. Make sure to put your name(s) on the top left corner!

Homework Writing Bay
Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper