An application of Excel: Probability and Data Analysis Tool — Descriptive Statistics

An application of Excel: Probability and Data Analysis Tool — Descriptive Statistics
(QuestiOnS 1 —4)
Television viewing reached a new h’gh when the Nielsen Comp.ny reported a mean daily iewng t.m of 8.35 hourS per household (USA Today). Use a normal prohabilit distribuiofl with a tandexd deviation of 2.5 hours to answer the following questions about daily te1e’ision viewing pr household.
Qstion I: What is the probability that a household ‘v’ews television less .han 7hcus”
Ouestioft2 What is the probability that a household ‘views televisicn betA eei -, arii 8 iours a day”
Question 3: How many hours of television ‘viewing mist a sehold t.ae n order to be in the top 5% of all television viewing households?
Lori Jeffery is a successful sales representative for a major pub!isher of cc liege textbcoks. Historically,
Lori obtains a book adoption on 25% of her sales calls. Viewing her sales calls for one month as sample
of all possible sales calls, assume that a statistical analysis of the data yi&ds a stan.ard errcr of the
proportion of 0.0625
Question 4: What is the probability that Lori will obtain bc’:k adoptions on 35% or mre of her sales calls
during a one-month period?
(Questions S — 7): An application of Excel ‘6Data Analysis — Descriptive Statistics
A simple random sample often employees of a large corporation provided the following information.
Determine the point estimate for the average a,e cf all emplcyees usii Excel “Data Ar.alysis:
Statistics” function.
Question 6: What is the point estimate for the standard deviation of tFe xrage age of a!! employees?
Ouestion7: Describe the point estimate, normal probability Jistribution, .nd standard normal probaility distribution in detail (One double space typed page).
Click Here For More Details on How to Work on this Paper......
Need a Professional Writer to Work on this Paper? Click Here and Get this Essay Done ………