State the null hypothesis from this example in cell A35. What does the value in cell A33 tell you about the hypothesis.

One sample t Test

We are now going to use Excel to test a hypothesis based on one given sample. We would like to know if the average cholesterol level of patients in intensive care is equal to 200 and for that reason we collect cholesterol level of 20 random people from various intensive care units.
Cholesterol level
154,168,134,201,208,220,225,228,201,207,168,211,203,254,268,198,298,135,154,189

We put our data in column A. In Cells A3-A22 we type our data and in cell A1 we type Cholesterol.
First let’s input the sample size n, that is how many elements in data do we have. In cell B24 we type N and in cell A24 we type 20. Second, we find degrees of freedom df=N-1. In cell B25 we type df and in cell A25 we type =A24-1. Next we evaluate the mean. We learned that already. In cell B26 we type Mean and in cell A26 we type =average(A3:A22).

Now let’s do standard deviation. In cell B27 we type SD and in cell A27 we type =stdev(A3:A22).

Next let’s do standard error of the mean. In cell B28 we type SEM and in cell A28 we type =A27/sqrt(A24).

We will do a one sample t test and for that we need a t value. . In cell B29 we type t and in cell A29 we type =(A26-200)/A28.
Now we evaluate the p value using Excel. In cell B31 we type TEST value and in cell A31 we type 200 In cell B32 we type Mean Difference. In cell A32 we type =A26-A31 .

In cell B33 we type Sig.(2-tailed). In cell A33 type =T.DIST.2T(A29,A25). Here T.DIST.2T means we are doing 2 tailed one sample TTEST. The first parameter A29 means we are computing the p value based on our calculated t value and we are comparing it to our threshold significance level of 0.05. The second variable represents degrees of freedom.

Exercises
Exercise 1. State the null hypothesis from this example in cell A35.

Exercise 2. What does the value in cell A33 tell you about the hypothesis. Do we reject the null hypothesis? Why? Put your explanation in cell A36.

Exercise 3. Instead of using Excel, we can look at the t chart. Find the critical value for the t distribution from that table. You may find it on page 335. Put that value in cell A37.

Exercise 4. Compare the t value in cell A29 to the table t value in cell A37. What is this comparison telling you about rejecting or not rejecting the null hypothesis. Put your explanation in cell A38.

State the null hypothesis from this example in cell A35. What does the value in cell A33 tell you about the hypothesis.

Place your order
(550 words)

Approximate price: $22

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:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
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