Question: Using the Toddler Height and Weight Spreadsheet , calculate a t test with the MS Excel Data Analysis Toolpack (two samples using unequal variances) for

  1. Using the Toddler Height and Weight Spreadsheet, calculate a t test with the MS Excel Data Analysis Toolpack (two samples using unequal variances) for sex and weight.
    1. Use 0 for the hypothesized mean difference and alpha at .05.
    2. You will need to sort the data by sex (male/female).
  2. Place your t test table on the same sheet as your dataset.
  3. Discuss (on the spreadsheet) the IV and DV. Format the hypotheses in the conventional format, based on the dataset provided. State two assumptions of the data (you may include a histogram of the data), and whether significance is inferred for differences in weight between male and female toddlers at ages 18 months.
  4. summarize results
Toddler Height and Length ages 18 months
Sex Weight in lbs Length in Inches Sex Weight in lbs Length in Inches
F 20.4 29.2 M 25.5 34.2
F 25.9 33.7 M 25 33.9
F 25.4 33.4 M 24.6 33.5
F 21 29.6 M 24.1 33.1
F 21.5 30.1 M 21.3 29.8
F 22 30.6 M 21.8 30.3
F 22.5 30.9 M 22.3 30.7
F 24.9 32.9 M 23.7 32.8
F 23 31.4 M 23.2 32.4
F 23.4 31.8 M 22.7 31.2
F 23.9 32.2 M 23.2 31.6
F 24.4 32.6 M 22.7 32

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!