MATH103: Statistics for Business - Statistics Assignment Help

Assignment Task

Question 1

All the working in EXCEL for this question must be submitted with the corresponding datafile.

a) Using Excel, obtain a Descriptive Statistics output for the numerical variable chosen in the dataset. (Mean, Mode, Range and Standard Deviation)*. Write one paragraph describing the data set using the information about the mean, mode, range, standard deviation.

b) For the variable selected in part a) using Excel to construct a histogram (with 8 classes)*. Write one paragraph describing the data set using the histogram. Comment on the shape of the distribution of the data.

c) Compare the median and mean in part a). Is there a link between your finding with your comments in Part b)?

d) Using an appropriate Excel output, construct a 90% confidence interval for the numerical variable chosen in part a)

Question 2

All the working in EXCEL for this question must be submitted with the corresponding datafile.

In this task you are to analyse your data and create a confidence interval to estimate the population difference in means between two groups that are independent.

Using the dataset selected by your group, what two groups are you estimating the population difference in means? Are these two groups independent from each other?

Using Excel obtain summary statistics (mean, standard deviation, and sample size) for each group. Find the critical value from t-distribution using Excel (you may use T.INV.2T or T.INV functions with appropriate probabilities).

The following formula is used to construct the confidence interval for difference in means between two populations that are independent.

a. Using Excel, construct the confidence interval (choose your own confidence level). Assume that the population variances are unknown but are equal. Also assume that these variables come from two populations that are normally distributed.*

b. Interpret confidence interval in the context of data.

Question 3

All the working in EXCEL for this question must be submitted with the corresponding datafile.

In this task you are to analyse your data for a difference in means.

Using the dataset selected by your group, what two groups are you comparing?

You are to test the following hypothesis:

Does your data show evidence for a difference in means between the two groups? (Use a two-tailed test unless you have some reason in advance to suspect a difference in a particular direction.)

1. Using Excel, obtain an output for a hypothesis test at 5% level of significance. Assume that the population variances of the two groups are equal. Also assume that these variables come from two populations that are normally distributed.*
2. Using the information in the output, conduct a hypothesis test in the space below. Make sure that you include the null and the alternative hypothesis, the decision rule and the value of the test statistics. Explain your decision and write a conclusion.

Question 4

All the working in EXCEL for this question must be submitted with the corresponding datafile.

In this task you are to analyse your data for a test to determine whether two numerical variables have a correlation.

Using the dataset selected by your group, what are the two numerical variables that you have chosen?

a) Using Excel, obtain a regression output. Also include a scatterplot. *

b) Determine the regression equation that may be used to predict the dependent variable from the independent variable.

c) Determine the regression equation that may be used to predict the dependent variable from the independent variable.

This MATH1031-Statistics Assignment has been solved by our Statistics Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered.

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.