This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor or one-way ANOVA is used to test the null hypothesis that the means of several populations are all equal. Below you can find the salaries on people who have a degree in
This example teaches you how to perform a single factor ANOVA (analysis of variance) in Excel. A single factor or one-way ANOVA is used to test the null hypothesis that the means of several populations are all equal. Below you can find the salaries on people who have a degree in
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Please use the ANOVA excel posted and the AnovA PPT posted to find the ANOVA analysis. The Data is present in the PPT with the steps.

Transcribed Image Text:12:44
Conferation
Covariance
Descriptive Statistics
Exponential Smoothing
F-Test Two-Sample for Variances
Fourier Analysis
Histogram
Anova: Single Factor
Input
Input Range
Grouped By:
Labels in first row
•3. Click in the Input Range box and select the range A2:C10.
•4. Click in the Output Range box and select cell E1.
Alpha 0.05
Output options
Qutput Range:
ONew Worksheet Py
ONew Workbook
5. Click
OK
SAS2 SCS10
Columns
O Bows
SEST
E
Anova: Single Factor
SUMMARY
Total
AA
Column 1
Column 2
Column 3
Groups
IN
ANOVA
Source of Variation
Between Groups
Within Groups
Help
?
OK
Cancel
Help
F
Count
9
7
9
SS
1085.84
786
1871.84
G
df
Sum Average Variance
435 48.33333
23.5
60
420
393 43.66667
32.33333
50.5
2
22
H
24
I
:
moodle.elms.edu
J
K
F
MS
P-value
F crit
542.92 15.19623 7.16E-05 3.443357
35.72727
(

Transcribed Image Text:12:44
This example teaches you how to perform a single
factor ANOVA (analysis of variance) in Excel. A single
factor or one-way ANOVA is used to test the null
hypothesis that the means of several populations are all
equal.
B
с
1 economics medicine history
42
69
35
52
53
54
40
40
49
58
53
53
GA
64
42
MT
43
64
50
44
55
39
45
56
55
52
39
54
40
Forec
2 2
2
3
4
5
6
7
8
9
10
11
A
What Forec Group Ungroup Subtotal
Ana
S
1 Data Analys
AA
Offline
D
1. On the Data tab, in the Analysis group, click Data
Analysis.
Hide Detai
=
Below you can find the salaries of
people who have a degree in
economics, medicine or history.
HO: μ. = μ2 = μ3
H1: at least one of the means is
different.
moodle.elms.edu
(
Expert Solution

Step 1
Given:
The given data is
Economics | Medicine | History |
42 | 69 | 35 |
53 | 54 | 40 |
49 | 58 | 53 |
53 | 64 | 42 |
43 | 64 | 50 |
44 | 55 | 39 |
45 | 56 | 55 |
52 | 39 | |
54 | 40 |
Step by step
Solved in 2 steps with 2 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman