I need help with a critical thinking assignment for my statistic class.
Fall 2020
Critical Thinking Assignment: Data Analysis Part 2 (50 points)
DUE DATE: OCTOBER 28
INSTRUCTIONS:
Using your sample data obtained from the student survey and using Microsoft Excel or your TI-84 calculator, fill in the values in the table below.
Table 1: Students with no dependents
|
|
Age |
GPA |
TCH comp |
HRS per/wk |
CRSE anxiety |
CRSE difficulty |
HRS ON HOMEWORK |
|
MEAN |
|
|
|
|
|
|
|
|
MEDIAN |
|
|
|
|
|
|
|
|
MODE |
|
|
|
|
|
|
|
|
STD DEVIATION |
|
|
|
|
|
|
|
|
VARIANCE |
|
|
|
|
|
|
|
|
Q1 |
|
|
|
|
|
|
|
|
Q2 |
|
|
|
|
|
|
|
|
Q3 |
|
|
|
|
|
|
|
|
IQR |
|
|
|
|
|
|
|
|
LIST ANY OUTLIERS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table 2: Students with dependents
|
|
Age |
GPA |
TCH comp |
HRS per/wk |
CRSE anxiety |
CRSE difficulty |
HRS ON HOMEWORK |
|
MEAN |
|
|
|
|
|
|
|
|
MEDIAN |
|
|
|
|
|
|
|
|
MODE |
|
|
|
|
|
|
|
|
STD DEVIATION |
|
|
|
|
|
|
|
|
VARIANCE |
|
|
|
|
|
|
|
|
Q1 |
|
|
|
|
|
|
|
|
Q2 |
|
|
|
|
|
|
|
|
Q3 |
|
|
|
|
|
|
|
|
IQR |
|
|
|
|
|
|
|
|
LIST ANY OUTLIERS |
|
|
|
|
|
|
|
1. Compare the mean and standard deviation using the variable Age for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean age of ___ and a standard deviation of ____
Students with no dependents had a mean age of _____ and a standard deviation of _____
Age Comparison
|
|
GROUPS |
|
|
|
Students with Dependents |
Students with no Dependents |
|
MEAN |
|
|
|
STD DEV |
|
|
Construct a boxplot for each group to show the distribution of ages using Excel.
2. Compare the mean and standard deviation using the variable GPA for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean GPA of ____ and a standard deviation of _____
Students with no dependents had a mean GPA of ___ and a standard deviation of ____
GPA Comparison
|
|
GROUPS |
|
|
|
Students with Dependents |
Students with no Dependents |
|
MEAN |
|
|
|
STD DEV |
|
|
Construct a boxplot for each group to show the distribution of GPA using Excel
3. Compare the mean and standard deviation using the variable Total Credit Hours Completed for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean total credit hour completed of ____and a standard deviation of ___
Students with no dependents had a mean total credit hour completed of _____ and a standard deviation of _____
Total Credit Hours Completed Comparison
|
|
GROUPS |
|
|
|
Students with Dependents |
Students with no Dependents |
|
MEAN |
|
|
|
STD DEV |
|
|
Construct a boxplot to show the distribution of total credit hours completed for each group using Excel
4. Compare the mean and standard deviation using the variable Hours work per week for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean hour work per week of ____and a standard deviation of ___
Students with no dependents had a mean hour work per week of _____ and a standard deviation of _____
Hours work per week comparison
|
|
GROUPS |
|
|
|
Students with Dependents |
Students with no Dependents |
|
MEAN |
|
|
|
STD DEV |
|
|
Construct a boxplot to show the distribution of hours work per week for each group using Excel
5. Compare the mean and standard deviation using the variable Course Anxiety for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean anxiety of __ and a standard deviation of __
Students with no dependents had a mean anxiety of ____ and a standard deviation of __
Course Anxiety comparison
|
|
GROUPS |
|
|
|
Students with Dependents |
Students with no Dependents |
|
MEAN |
|
|
|
STD DEV |
|
|
Construct a boxplot to show the distribution of anxiety for each group using Excel
6. Compare the mean and standard deviation using the variable Course Difficulty for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean course difficulty of _ and a standard deviation of _
Students with no dependents had a mean course difficulty of ____ and a standard deviation of _____
Course Difficulty comparison
|
|
GROUPS |
|
|
|
Students with Dependents |
Students with no Dependents |
|
MEAN |
|
|
|
STD DEV |
|
|
Construct a boxplot to show the distribution of course difficulty for each group using Excel
7. Compare the mean and standard deviation using the variable Hours spent on homework for both groups. Fill in the blanks below with the mean and std dev. for each group.
Students with dependents had a mean hour on homework of _____ and a standard deviation of _____
Students with no dependents had a mean hour on homework of _____ and a standard deviation of _____
Hours spent on homework comparison
|
|
GROUPS |
|
|
|
Students with Dependents |
Students with no Dependents |
|
MEAN |
|
|
|
STD DEV |
|
|
Construct a boxplot to show the distribution of hours on homework for each group using Excel