Excel Tutorial for MATH1070
- Create a pie chart
- Create a bar graph
- Creat a histogram
- Create a time plot
- Create a scatter plot
- Add a trend line to a scatter plot
- Find the sum: Sum Function
- Find the mean: Average Function
- Find the median: Median Function
- Find the quartiles: Quartile Function
- Find the variance: Var Function
- Find the standard deviation: Stdev Function
- Find the cumulative percentage of a given z-score: Normsdist Function
- Find the z-score of a given cumulative percentage: Normsinv Function
- Find the correlation coefficient: Correl Function
- Find the slope of the linear regression line: Slope Function
- Find the y-intercept of the linear regression line: Intercept Function
- Predict the y-value by linear regression: Forecast Function
- Generate a random number: Rand Function