Question

In: Statistics and Probability

VISTA manager William Phogbound suspects that 50% of his volunteers are over 65 years old. A...

VISTA manager William Phogbound suspects that 50% of his volunteers are over 65 years old. A survey of 16 volunteers reveals that 7 are over age 65. What can be said about Phogbound’s assertion? Present research and null hypotheses and evaluate them.

How would I show this in MS Excel?

Solutions

Expert Solution


Related Solutions

In 1869, William E. Story promised his nephew, William E. Story II (then sixteen years old),...
In 1869, William E. Story promised his nephew, William E. Story II (then sixteen years old), $5,000 (about $120,000 in today’s money) if “Willie” would abstain from drinking alcohol, smoking, swearing, and playing cards or billiards for money until the nephew reached twenty-one years of age. All of these were legally permissible activities for the teenager at that time in New York State. Willie accepted his uncle’s promise and did refrain from the prohibited acts until he turned twenty-one. When...
William Davis is 62 years old. He was employed as a postal worker until his declining...
William Davis is 62 years old. He was employed as a postal worker until his declining eyesight forced him into early retirement a few months ago. His wife, Mildred, died last year of complications from diabetes after a prolonged and expensive hospitalization. Mr. Davis does not trust the medical community, and because of this distrust, he has not been to a doctor since his wife’s death. Mr. Davis is not considered legally blind, but his presbyopia and an advancing cataract...
William Davis is 62 years old. He was employed as a postal worker until his declining...
William Davis is 62 years old. He was employed as a postal worker until his declining eyesight forced him into early retirement a few months ago. His wife, Mildred, died last year of complications from diabetes after a prolonged and expensive hospitalization. Mr. Davis does not trust the medical community, and because of this distrust, he has not been to a doctor since his wife’s death. Mr. Davis is not considered legally blind, but his presbyopia and an advancing cataract...
William Davis is 62 years old. He was employed as a postal worker until his declining...
William Davis is 62 years old. He was employed as a postal worker until his declining eyesight forced him into early retirement a few months ago. His wife, Mildred, died last year of complications from diabetes after a prolonged and expensive hospitalization. Mr. Davis does not trust the medical community, and because of this distrust, he has not been to a doctor since his wife’s death. Mr. Davis is not considered legally blind, but his presbyopia and an advancing cataract...
1. You are now 50 years old and plan to retire at age 65. You currently...
1. You are now 50 years old and plan to retire at age 65. You currently have a stock portfolio worth $150,000, a 401(k) retirement plan worth $250,000, and a money market account worth $50,000. Your stock portfolio is expected to provide annual returns of 12 percent, your 401(k) investment will earn 9.5 percent annually, and the money market account earns 5.25 percent, compounded monthly. (12 points) a. If you do not save another penny, what will be the total...
John Wayne is 50 years old and plans to retire in 20 years. His new employer...
John Wayne is 50 years old and plans to retire in 20 years. His new employer provides 401K retirement plan and he plans to accumulate $1,000,000 in his retirement account by age of 70. Use Excel to answer the following questions. How much he has to contribute per year at return of 7% per year to reach his retirement goal. Redo part (a) if john decides to increase his contribution 0.50% per year over 20 years. c.Redo part (a) if...
Steve Hitchcock is 40 years old today and he wishes to accumulate $518,000 by his 65...
Steve Hitchcock is 40 years old today and he wishes to accumulate $518,000 by his 65 th birthday so he can retire to his summer place on Lake Hopatcong. He wishes to accumulate this amount by making equal deposits on his 40 th through his 64 th birthdays. What annual deposit must Steve make if the fund will earn 9% interest compounded annually? (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g....
Nelson has accumulated $168,000 in his retirement account. He is 65 years old and plans to...
Nelson has accumulated $168,000 in his retirement account. He is 65 years old and plans to retire this fall. He's trying to determine how much income he will have to live on during his retirement years. Nelson is a relatively conservative investor and has decided that he wants to keep his retirement funds invested 60 percent in long-term corporate bonds and 40 percent in stocks. He is estimating that he will earn an average annual rate of return of 12...
Maxine Gray is single and over 65 years old. She received the following in 2020: Interest...
Maxine Gray is single and over 65 years old. She received the following in 2020: Interest from certificates of deposit $ 6,000 Tax-exempt interest 9,000 Taxable dividends 8,000 Taxable pension 20,000 Social Security benefits 14,000 Required: Determine the taxable amount of Ms. Gray’s Social Security benefits. You must show all supporting computations to earn full credit.
John moses is 65 years old and his life expectancy of 12 more year. he wish...
John moses is 65 years old and his life expectancy of 12 more year. he wish to invest $ 20,000 in an annuity that will make a level payment at the end year until his death if the interest rate is 8% , what income can Mr moses expect to receive each year?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT