This video covers a few topics using the data analysis tool.
After this video you should be able to:
a) Find and use data analysis on excel to calculate statistics
b) Calculate the mean, median, mode, standard deviation, range and coefficient variation on a variable set of data in excel.
c) Conduct a confidence interval in excel.
d) Complete a T-test in excel to help complete a hypothesis test.
e) Conduct a linear regression analysis output from excel and create a scatter diagram.
After this video you should be able to:
a) Find and use data analysis on excel to calculate statistics
b) Calculate the mean, median, mode, standard deviation, range and coefficient variation on a variable set of data in excel.
c) Conduct a confidence interval in excel.
d) Complete a T-test in excel to help complete a hypothesis test.
e) Conduct a linear regression analysis output from excel and create a scatter diagram.
- Category
- Tech
Sign in or sign up to post comments.
Be the first to comment