# 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.

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Nursing
Customer 453627, January 23rd, 2020
Military
very good job
Customer 456821, June 15th, 2022
Good work.
Customer 458115, May 10th, 2022
Other
Thank you again for another beautifully written paper and writing the thoughts as if they were my own.
Customer 452455, February 26th, 2023
Other
Good job
Customer 456821, December 26th, 2022
Commendable. Review credentials alignment in APA cover page. Student paper https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/apa_sample_paper.html
Customer 453187, March 31st, 2022
Military
excellent work
Customer 456821, August 31st, 2022
Healthcare & Medical
Excellent work.
Customer 452441, May 16th, 2022
Home Repair & Home Maintenance
Great work
Customer 452441, April 21st, 2022
SEO
Well researched
Customer 463679, April 15th, 2023
Other
The writer did a phenomenal job with the Research Report #1: Data Breach Incident Analysis & Report. All expectations were met and exceeded! Thank you for delivering an amazing product and a HUGE thank you to the customer service department for sending me an email to let me know the paper was checked to quality assurance team to ensure the paper was within standards of the instructions.
Customer 452455, February 3rd, 2023
I got a B on the paper. Which is okay. But would of preferred an A paper since I paid a bit more for better writing.
Customer 454445, June 2nd, 2020
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend