Excel Homework

posted in: Do my essay for me cheap | 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 1101DHM 2003DHM 2403DHM 3103DHM 4031
72828591100
65818792100
6083889099
58738789100
73778593100
5974859198
5576859099
62788689100
6576869299
69778793100
7275889099
6478858998
6779859099
4575869399
67768394100
71778892100
6975879499
71798593100
6974849499
6878839398
  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]

BeforeAfter
1.36.5
2.58.7
2.39.8
8.110.2
5.07.9
7.06.5
7.58.7
5.27.9
4.48.7
7.69.1
9.08.4
7.66.4
4.57.2
1.15.8
5.66.9
6.25.9
7.07.6
6.97.8
5.67.3
5.24.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]

KarateKung Fu
6.759.75
7.659.00
9.008.05
5.508.10
5.259.35
6.959.05
6.158.05
5.358.15
7.759.85
5.058.90
7.359.60
6.059.40
6.558.60
7.958.80
8.609.20
6.508.90
6.459.90
5.558.20
6.708.50
5.408.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 ($)
1000100
2000200
4000360
8000720
160001280
320002560
640004480
1280008960
25600015360
51200030720
102400051200
2048000102400
4096000163840
8192000327680
16384000491520

 

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