# Statistics in excel | Statistics homework help

need solutions calculations but also excel solution

Q1.

For each of the following claims mention what type of test should be used (one-tail, two-tail) and set up the null and alternate hypothesis. Consider that the critical value is = CV (like for example 1.96). For each H0, mention the acceptance range. a) The 87Cents Store claims that their daily profit is at least \$5000. b) The Pastry shop claims that its chocolate cookies have no more than 50% chocolate per cookie. c) PS193 claims that its students scored in the 95thile.

Q2. A researcher wishes to test the claim that the average cost of tuition and fees at a 4-year college at least \$7000. She selects a random sample of 81 colleges and finds the mean to be \$6900. The standard deviation is \$500. a. Is there evidence to support the claim at α = .06? b. Suppose no claim was made but the researcher is thinking of making a claim using a 95% two-sided confidence interval. Using the same data, construct the CIE interval.

Q3. An educator claims that the average salary of substitute teachers in New York is at most \$100 per day. A random sample of ten school districts is selected, and the daily salaries are shown. Is there evidence to support the claim at α = .05? 85 70 110 95 90 102 87 78 69 100 Note: you need to compute the average and stdev.

Q4 Short answer questions and multiple choice questions:

1. A confidence interval of 90% was used to estimate the proportion of customers who buy at least two items during their shopping mall experience. A random sample of 100 customers produced a confidence interval of: 49% +/- 4%. What is the best way to explain the result?

2. The range of values that the correlation coefficient can take is: a. –infinite to + infinite b. 0% to 100% c. -1 to 1 d. 0 to 100

3. A coefficient of correlation equal to -.78 shows: a strong correlation a weak correlation a moderate correlation r value is invalid

Q5. Consider the following excel regression analysis output. Explain the significance of the r, p, F value; Give the regression equation.

Q6. One of the stores is a proud sponsor of the college soccer team. They constantly try to raise money for the team and they want to determine if there is any type of relationship between the amount of contribution and the years that the alumnus has been out of school. Years (X) 1 5 3 10 6 6 2 Contribution (Y) 250 100 110 0 70 80 175

a. Using Excel construct a scatter plot. Discuss the output of the scatter plot.

b. Give (or calculate) the correlation coefficient.

c. Give (or calculate) the coefficient of determination.

d. Give (or calculate) the regression equation coefficients; Give the equation of regression.

e. (very important) Based on the above values, in detail draw the conclusion:  Discuss the correlation coefficient r  Discuss the coefficient of determination r2  Discuss in detail the meaning of the regression equation (x=0; y=0) f. How much would be the contribution of a student who graduated 7 years ago? After how many years after graduations the alumni will stop contributing.

Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.

Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.

Affordable Prices

Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.

On-Time delivery

We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.

100% Originality

At Essay USA, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.

Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: support@acmehomework.com.

Try it now!

## Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

Essay USA has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.

## Essay Writing Services

At Essay USA, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.