Question
i need the excel formula


3. Write either the R code or Excel formula that gives us the answer to the following question. We are testing a one-tailed t
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Here let we consider the distribution is of normal with mean 500 and standard deviation 100.

Then the critical value for 5% level of significance is given by R code which is given by

qnorm(0.05,500,100)

The Output is as follows :

335.5146

The the required raw score value is 335.5146

Add a comment
Know the answer?
Add Answer to:
i need the excel formula 3. Write either the R code or Excel formula that gives...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • I need help with 5,6,7 and question 8. Please write neatly so I can understand thanks...

    I need help with 5,6,7 and question 8. Please write neatly so I can understand thanks SCWK 310 ONLINE- Practice Worksheet 2Worth 30 points. 5. Determine the z score. You score 650 on the verbal GRE text. Calculate the z score to determine how well you scored compared to the general population of test takers. The population mean is 469 and the population standard deviation is 119. (3 points. 6. A population of raw scores is normally distributed with a...

  • The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate...

    The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate d.f. as the row header. For a right-tailed test, the column header is the value of α found in the one-tail area row. For a left-tailed test, the column header is the value of α found in the one-tail area row, but you must change the sign of the critical value t to −t. For a two-tailed test, the column header is the value...

  • The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate...

    The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate d.f. as the row header. For a right-tailed test, the column header is the value of α found in the one-tail area row. For a left-tailed test, the column header is the value of α found in the one-tail area row, but you must change the sign of the critical value t to −t. For a two-tailed test, the column header is the value...

  • 1. Submit your el 2. The assignment can be done individually or in small groups (2-3...

    1. Submit your el 2. The assignment can be done individually or in small groups (2-3 students). 3. The names o assignment electronically through iLearn by the due date: Friday, August 3. fall members of a group must be clearly stated in the work submitted for grading. Only one submission per group, please! 4. The answers to quest tions 1 11 below, including the graphs, must be clearly stated in a single word or pdffile separate from your code or...

  • I need to do these questions by only using Excel but want to make sure all...

    I need to do these questions by only using Excel but want to make sure all my functions are correct. I would appreciate a lot if you could help me with this question. Thanks! 3. The aim of this exercise is to perform a hypothesis test involving a population mean where the population standard deviation is known. You may follow Pg 131-138 of your textbook to complete the calculations involved in this exercise. Experience has shown that the scores obtained...

  • Confused on calculating the critical value w/ excel. I got 1.65 instead of 1.645. ayout Formulas...

    Confused on calculating the critical value w/ excel. I got 1.65 instead of 1.645. ayout Formulas Data Review view Help Tell me what you want to do =T.INV.2T(0.1,368) Chapter 10 Homework Е F Н (Or Areas Under t-Distribution Curve) 0.95 0.025 0.05 0.99 0.005 0.01 0.8 0.1 0.2 0.98 0.01 0.02 0.7 0.15 0.3 0.9 0.05 0.1 BUS204 Hybrid W130PM - Fall 2019 Values of t Homework: Chapter 10 Homework 1.0877 1.3634 1.7959 2.2010 2.7181 3.1058 Save 1.0832 1.0795 1.3562...

  • show excel formulas please 2. Discrete and Continuous Probability Distributions: In the following three parts, write...

    show excel formulas please 2. Discrete and Continuous Probability Distributions: In the following three parts, write the formula and value for the cases shown. (a) X is the binomial random variable with n = 50 and p = 0.65. [8 points) Case Excel Formula Value PIX> 25) P(X < 35) OMBE 2787 Makeup Test Summer 2020 (b) Suppose that a bank receives an average of 7 bad checks per day and this process can be modeled as a Poisson distribution....

  • The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate...

    The Student's t distribution table gives critical values for the Student's t distribution. Use an appropriate d.f. as the row header. For a right-tailed test, the column header is the value of α found in the one-tail area row. For a left-tailed test, the column header is the value of α found in the one-tail area row, but you must change the sign of the critical value t to −t. For a two-tailed test, the column header is the value...

  • The alternate hypothesis is a statement that the value of a population parameter (such as proportion,...

    The alternate hypothesis is a statement that the value of a population parameter (such as proportion, mean, or standard deviation) is equal to some claimed value. True O False A Uniform probability distribution is applicable to the scenarios where the set of possible outcomes can take on values in a continuous range (e.g. real numbers), such as the temperature on a given day." True False A larger standard deviation indicates that the data is further away from; hence, the normal...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT