Use the following formulas to return the t-scores you need in the above formula from Excel....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the following formulas to return the t-scores you need in the above formula from Excel. =t.inv(probability, degrees of freedom) To retrieve the lower t (t. part of formula): probability = a/2 and degrees of freedom = n-1 To retrieve the upper t (t part of formula): probability = (1-a/2) and degrees of freedom = n-1 Confidence interval for a sample proportion: ptmargin of error [p(1-p) p±²H* Similarly, we can deconstruct this formula as well. p+z₂* √[[P(1-P)] Using this version of the formula, if I retrieve a z-value = -2, I would directly plug that value in as z₁: Lower bound: p + (-2)*, where ZH is the t-score for the upper bound (z-high) Upper bound: p + Zµ* where z, is the t-score for the lower bound (z-low) where zi is the t-score for the upper bound (z-high) Use the following formula to return the z-scores you need in the above formula from Excel. =norm.s.inv(probability) To retrieve the lower z (z. part of formula): probability = a/2 To retrieve the upper z (z part of formula): probability = 1 -a/2 A sample of 41 triathlon participants required an average time of 105 minutes to complete the race with a standard deviation of 20 minutes. 1. Start constructing the 90% confidence interval for the population mean. What are t, and th? a = 1-confidence level = 1-0.9 -0.1 a/2 = 0.05 Using Excel find the lower t-score: t.inv(0.05, 40) = -1.6839 Note: Excel will give you very precise t-scores, I will round these at the fourth decimal place. 2. Start constructing the 90% confidence interval for the population mean. What is the margin of error? Hint: use this formula → margin of error = t *(-) 3. What is the 90% confidence interval for the population mean? 4. What is the 95% confidence interval for the population mean? 5. Is the interval range for the 95% confidence interval larger or smaller than the 90% confidence interval? In a sample of a large number of teaching union members, 90% intend to vote for the new labor contract. 6. What is the minimum sample size needed to meet the condition: n * p > 5? 7. What is the minimum sample size needed to meet the condition: 12* (1-p) ≥ 5? 8. If n = 50, what is the 95% confidence interval? 9. If n = 500, what is the 95% confidence interval? 10. Is the interval range for the 95% confidence interval larger or smaller with n=500 compared to with n=50? Formulas Confidence interval for a sample mean: * + margin of error x ±t, * ( We can deconstruct this formula to get the lower and upper bound values separately. where th is the t-score for the upper bound (t-high) Note: since I am suggesting below that you retrieve both the lower and upper t-scores (this practice will help us in future work), it may be easier to think of the lower bound formula using this version of the equation where you can directly plug-in the negative t-value you retrieve from Excel: Lower bound = x + ₁ + where t, is the t-score for the lower bound (t-low) For example, if I retrieve a t-value = -2, I would directly plug that value in as tu: Lower bound = x + (-2)*() where th is the t-score for the upper bound (t-high) Upper bound = x + tµ * | We then represent it as an interval range = [lower bound, upper bound] Use the following formulas to return the t-scores you need in the above formula from Excel. =t.inv(probability, degrees of freedom) To retrieve the lower t (t. part of formula): probability = a/2 and degrees of freedom = n-1 To retrieve the upper t (t part of formula): probability = (1-a/2) and degrees of freedom = n-1 Confidence interval for a sample proportion: ptmargin of error [p(1-p) p±²H* Similarly, we can deconstruct this formula as well. p+z₂* √[[P(1-P)] Using this version of the formula, if I retrieve a z-value = -2, I would directly plug that value in as z₁: Lower bound: p + (-2)*, where ZH is the t-score for the upper bound (z-high) Upper bound: p + Zµ* where z, is the t-score for the lower bound (z-low) where zi is the t-score for the upper bound (z-high) Use the following formula to return the z-scores you need in the above formula from Excel. =norm.s.inv(probability) To retrieve the lower z (z. part of formula): probability = a/2 To retrieve the upper z (z part of formula): probability = 1 -a/2 A sample of 41 triathlon participants required an average time of 105 minutes to complete the race with a standard deviation of 20 minutes. 1. Start constructing the 90% confidence interval for the population mean. What are t, and th? a = 1-confidence level = 1-0.9 -0.1 a/2 = 0.05 Using Excel find the lower t-score: t.inv(0.05, 40) = -1.6839 Note: Excel will give you very precise t-scores, I will round these at the fourth decimal place. 2. Start constructing the 90% confidence interval for the population mean. What is the margin of error? Hint: use this formula → margin of error = t *(-) 3. What is the 90% confidence interval for the population mean? 4. What is the 95% confidence interval for the population mean? 5. Is the interval range for the 95% confidence interval larger or smaller than the 90% confidence interval? In a sample of a large number of teaching union members, 90% intend to vote for the new labor contract. 6. What is the minimum sample size needed to meet the condition: n * p > 5? 7. What is the minimum sample size needed to meet the condition: 12* (1-p) ≥ 5? 8. If n = 50, what is the 95% confidence interval? 9. If n = 500, what is the 95% confidence interval? 10. Is the interval range for the 95% confidence interval larger or smaller with n=500 compared to with n=50? Formulas Confidence interval for a sample mean: * + margin of error x ±t, * ( We can deconstruct this formula to get the lower and upper bound values separately. where th is the t-score for the upper bound (t-high) Note: since I am suggesting below that you retrieve both the lower and upper t-scores (this practice will help us in future work), it may be easier to think of the lower bound formula using this version of the equation where you can directly plug-in the negative t-value you retrieve from Excel: Lower bound = x + ₁ + where t, is the t-score for the lower bound (t-low) For example, if I retrieve a t-value = -2, I would directly plug that value in as tu: Lower bound = x + (-2)*() where th is the t-score for the upper bound (t-high) Upper bound = x + tµ * | We then represent it as an interval range = [lower bound, upper bound]
Expert Answer:
Answer rating: 100% (QA)
Solutions Step 1 To construct the confidence interval for the population mean you can follow these steps Explanation 1 Calculate the critical tvalues tL and tH for the given confidence level and degre... View the full answer
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
Confidence Interval for Sample of Size n 1 Based on the article An Effective Confidence Interval for the Mean with Samples of Size One and Two, by Wall, Boen, and Tweedie (American Statistician,...
-
Using the Confidence Interval for a Proportion applet on the text CD, lets check that the large-sample confidence interval for a proportion may work poorly with small samples. Set n = 10 and p =...
-
Using techniques from Section 8.2, we can find a confidence interval for μd. Consider a random sample of n matched data pairs A, B. Let d = B - A be a random variable representing the...
-
Why does the magnetization current impose an upper limit on the voltage applied to a transformer core?
-
Why does the general control model begin with planning activities?
-
A company owns a building that it rents for $ 3 , 0 0 0 per month. No payment was received for November or December although company officials do expect payment to be collected. If nothing has yet...
-
A steam condenser has separate air and condensate pumps. The entry to air pump suction is screened. Steam enters the condenser at \(38^{\circ} \mathrm{C}\) and the condensate is removed at...
-
Skie Incorporated had the following transactions involving current assets and current liabilities during February 2012. Feb. 3 Collected accounts receivable of $15,000. 7 Purchased equipment for...
-
1/ True, False or Uncertain? Justify your response to the following statements. a) Consider the new residential development in north Toronto. A 1300 sq. ft. house was recently sold for $600,000. The...
-
Write a project management plan. we have a template and project description. we need to edit the template(table of contents) with our own ideas. CPSC 8820-01 Project Management Plan Your Unique...
-
Sold obsolete store equipment for $630 cash. The equipment originally cost $2,105 and depreciation to March 31 of this year (the end of the first quarter) totals $1,200. The asset depreciates on a...
-
Research market data and trends in portfolio management and summarize the trend that you believe will impact portfolio management the greatest in the years ahead, use your independent research to...
-
A loan of $ 1 0 , 0 0 0 is being repaid with annual payments of $ 1 , 5 0 0 for n years. The total principal paid in the first payment is $ 6 8 5 . 5 8 . Calculate the interest rate on the loan....
-
What causes the most uncertainty about your personal finance? getting started, taking action, or evaluating progress and taking the necessary corrective action with regards to your finances? How is...
-
Review Tesla's economic profit trend for the past five years. Is this trending in the right direction, too high, too low, misrepresented because of some factor? How or why?
-
A. Three and a half years ago, Bob purchased 1200 units of a fund with an NAV of $16.75. The NAV is now $36.50 and the fund had a 7 percent redemption fee declining at 1 percent per year and based on...
-
The cost sheet of a manufacturing company is given below: Particulars Opening stock of materials Add: Purchases Less: Closing stock of materials Material consumed Add: Direct wages Chargeable...
-
As of January 1, 2018, Room Designs, Inc. had a balance of $9,900 in Cash, $3,500 in Common Stock, and $6,400 in Retained Earnings. These were the only accounts with balances in the ledger on January...
-
R. Stichler et al. compared two methods of measuring treadwear in their paper "Measurement of Treadwear of Commercial Tires" (Rubber Age, Vol. 73:2). Eleven tires were each measured for treadwear by...
-
The area under a density curve that lies to the left of 60 is 0.364. What percentage of all possible observations of the variable are a. Less than 60? b. At least 60?
-
From the paper Effects of Chronic Nitrate Exposure on Gonad Growth in Green Sea Urchin Strongylocentrotus droebachiensis (Aquaculture, Vol. 242, No. 14, pp. 357363) by S. Siikavuopio et al., we found...
-
Consider the flow of a perfect gas along a Fanno line. Show that the pressure at the * reference state is given by the relation 1/2 m 2RT, P Ayge(y+1)
-
Air flows in an 8-cm-inside diameter pipe that is \(4 \mathrm{~m}\) long. The air enters with a Mach number of 0.45 and a temperature of \(300 \mathrm{~K}\). (a) What friction factor would cause...
-
Air enters a duct with a mass flow rate of \(35 \mathrm{lbm} / \mathrm{sec}\) at \(T_{1}=520^{\circ} \mathrm{R}\) and \(p_{1}=20 \mathrm{psia}\). The duct is square and has an area of \(0.64...
Study smarter with the SolutionInn App