This article will guide you to analyze variance in Excel.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Analysis of variance
This article shows you how to perform ANOVA (analysis of variance) in Excel. Below you can find the salaries of people with degrees in economics, medicine or history.
To perform a single-factor analysis of variance, you will do the following:
1. In the Data panel, select Data Analysis.
2. 2. Select Anova: Single Factor and click OK.
3. Click Input Range and select the range A2:C10.
4. Click Output Range and select the range E1.
5. Press OK
Result
In addition, you can also view many other excel articles here.
