Excel Homework

posted in: Research Paper | 0
  1. A professor with a sleepy accent teaches you five different DHM classes. The professor wants to know if there is a difference in the performance in the five classes that he teaches. Is the performance of the students different across the four classes? List the null and alternative hypotheses, and draw conclusions.
[2.5pts: Excel – 2pts & written part – 0.5pts]
DHM 1101 DHM 2003 DHM 2403 DHM 3103 DHM 4031
72 82 85 91 100
65 81 87 92 100
60 83 88 90 99
58 73 87 89 100
73 77 85 93 100
59 74 85 91 98
55 76 85 90 99
62 78 86 89 100
65 76 86 92 99
69 77 87 93 100
72 75 88 90 99
64 78 85 89 98
67 79 85 90 99
45 75 86 93 99
67 76 83 94 100
71 77 88 92 100
69 75 87 94 99
71 79 85 93 100
69 74 84 94 99
68 78 83 93 98
  1. Students take singing lessons from Norah Jones over the Spring semester for three months. They rate their singing skills before and after the singing lessons on a scale from 1-10 (1- very poor; 10- very good). Did the singing lessons help improve the student’s singing skills? State the null and alternative hypothesis. Use excel to do the analysis and draw conclusions. Use a statistical significance of α = 0.05.
[2.5pts: Excel – 2pts & written part – 0.5pt]
Before After
1.3 6.5
2.5 8.7
2.3 9.8
8.1 10.2
5.0 7.9
7.0 6.5
7.5 8.7
5.2 7.9
4.4 8.7
7.6 9.1
9.0 8.4
7.6 6.4
4.5 7.2
1.1 5.8
5.6 6.9
6.2 5.9
7.0 7.6
6.9 7.8
5.6 7.3
5.2 4.6
  1. Individuals from three different age groups (old, middle-aged and young) with 12 individuals in each group each eat three different varieties of ice-cream and rate their happiness level after eating the ice-cream (1- extremely unhappy; 10- extremely happy). Test if there is a difference in happiness level across the age groups and ice-cream flavors. Lastly, test if there is an interaction effect. State all hypotheses (for two factor and three factor interactions you can list them using words) and draw conclusions.
[2.5pts: Excel – 2pts & written part – 0.5pts]
  1. The Hulk is thinking about offering Karate or Kung Fu lessons. As a trail run he assigns few students to the Karate Group and the Kung Fu group and offers free class. After the free classes her asks students in each class to rank their classes using a Likert scale (1- crappy class and 10- super awesome class). His friend Black Widow hypothesis that the Kung Fu group will rate the class more favorably. Was Black Widow right? Carry out a statistical analysis and draw conclusions. Use α = 0.05.
[2.5pts: Excel – 2pts & written part – 0.5pts]
Karate Kung Fu
6.75 9.75
7.65 9.00
9.00 8.05
5.50 8.10
5.25 9.35
6.95 9.05
6.15 8.05
5.35 8.15
7.75 9.85
5.05 8.90
7.35 9.60
6.05 9.40
6.55 8.60
7.95 8.80
8.60 9.20
6.50 8.90
6.45 9.90
5.55 8.20
6.70 8.50
5.40 8.95
  1. There is a class of 24 students (12 male and 12 female). Calculate the mean, median, mode, range and standard deviation for the whole class, and boys and girls separately. The following are the heights of the students:

Boys – 72”, 70”, 75”, 76”, 69”, 73”, 74”, 75”, 76”, 77”, 72”, 71”

Girls – 64”, 63”, 65”, 66”, 67’, 68”, 69”, 68”, 68”, 69”, 69”, 67”

After you have calculated the mean, median, mode, range and standard deviation, determine the percentiles for the shortest and tallest boy and girl. Use 70.15in and 2.71in as the mean and standard deviation respectively for the boys. Next, use 65.13in and 2.08in as the mean and standard deviation for the girls.

Next, plot the average and standard deviation using a column chart. Show the standard deviation as an error bar on the graph. Do include a chart title and also label the x-axis and y-axis.

Lastly, highlight all heights above 72” for the boys using a blue color font and 66” for the girls using a green color font. Use conditional formatting.

[3pts: Excel]
  1. Create a scatter plot based on the data below. After you create a scatter plot, add a trend-line and show the equation on the plot. Next, using the equation estimate how much an individual making $ 32768000/month would likely spend on food/month.
[2pts: Excel]
Income ($) Amount spent on food ($)
1000 100
2000 200
4000 360
8000 720
16000 1280
32000 2560
64000 4480
128000 8960
256000 15360
512000 30720
1024000 51200
2048000 102400
4096000 163840
8192000 327680
16384000 491520

 

VanillaStrawberryChocolate

Young10.08.07.5

9.08.58.0

8.09.07.5

9.08.08.0

10.08.08.0

9.58.07.5

9.08.06.5

8.58.07.5

10.08.57.0

9.08.07.0

8.08.07.0

9.08.06.5

Middle Age8.05.07.0

7.54.07.0

7.03.57.0

7.54.07.0

8.05.57.0

8.04.07.5

7.06.07.5

7.04.57.0

8.55.07.5

7.05.06.5

8.05.57.0

7.06.06.5

Old5.08.010.0

6.07.59.5

7.07.010.0

7.57.59.5

6.08.010.0

6.08.010.0

5.07.010.0

5.57.09.0

6.58.59.5

6.57.010.0

6.08.09.5

5.57.010.0

 

Last Updated on April 15, 2020 by Essay Pro