excel assigment

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]

2. 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]

3. 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]

4. 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]

5. 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]

6. 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]

Assigned: April 14th, 2020 at 6:00pm

Due: April 15th, 2020 by midnight

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