statistics in excel

 need solutions calculations but also excel solution
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. 

Don't use plagiarized sources. Get Your Custom Essay on
statistics in excel
Just from $13/Page
Order Essay

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 of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
error: Content is protected !!
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code BEGOOD