Write For Us

Microsoft Excel Data Analysis Tool For Statistics Mean, Median, Hypothesis, Regression

E-Commerce Solutions SEO Solutions Marketing Solutions
248 Views
Published
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.
Category
Tech
Sign in or sign up to post comments.
Be the first to comment