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
- 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.
- Use 0 for the hypothesized mean difference and alpha at .05.
- You will need to sort the data by sex (male/female).
- Place your t test table on the same sheet as your dataset.
- 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.
- 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
