Answered: *** TO BE DONE WITH THE USE OF EXCEL***…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

*** TO BE DONE WITH THE USE OF EXCEL***

***FOR MATCHED PAIR DO: BEFORE - AFTER***

***FOR INDEPENDENT SAMPLES DO: BEFORE AS SAMPLE 1 AND AFTER AS SAMPLE 2***

A large college would like to determine whether their college educator development training has had an effect on students' opinions on their professor’s teaching. A sample of student feedback scores before and after the training is provided below (also available for download here Feedback.xlsx). At a 5% level of significance, can you conclude that there has been an improvement since the training? YOU CAN ASSUME THE POPULATION TO BE NORMALLY DISTRIBUTED.

Average Professor Feedback Score (5 points max)
Random Sample Before Training (Points)	Random Sample After Training (Points)
3.52	3.81
3.54	3.5
3.87	3.99
3.39	3.28
4.01	4.28
4.25	4.2
3.65	4.1
4.46	4.85
3.39	3.49
3.84	4.23
3.5	3.72
4.5	4.84
3.94	4.11
3.56	3.81
4.3	4.72
3.55	3.62
4.11	4.35
4.03	4.36
3.58	4.03
3.79	4.05
4.16	4.24
3.78	3.66
4.24	4.44
4.31	4.45
4.41	4.87
3.59	3.8
4.12	4.47
3.85	4.28
3.61	4.07
3.91	4.4
4.22	4.49

b) p-value:

c) Conclusion:

Features Features Normal distribution is characterized by two parameters, mean (µ) and standard deviation (σ). When graphed, the mean represents the center of the bell curve and the graph is perfectly symmetric about the center. The mean, median, and mode are all equal for a normal distribution. The standard deviation measures the data's spread from the center. The higher the standard deviation, the more the data is spread out and the flatter the bell curve looks. Variance is another commonly used measure of the spread of the distribution and is equal to the square of the standard deviation.

Expert Solution