Question

In: Statistics and Probability

Reading Savneet brows furrowed as she examined the Excel file that Noor had emailed her. She...

Reading

Savneet brows furrowed as she examined the Excel file that Noor had emailed her. She let out a sigh as she started to think how this revelation might affect the bottom line of Rent-o-Rama, her company’s budget rental car service. Noor had unintentionally noticed a troubling trend. Now it was up to Savneet to see if there was any validity to the alleged pattern. With car services like Uber showing up, people were renting cars for short trips less and less. What Noor noticed was that lately when someone did rent a car, they were going greater distances than before, say to Banff rather than to Airdrie.

            Noor had originally brought this to Savneet’s attention because she thought that it was good news. The more kilometers on the car, the more the customers paid, which meant more revenue. But Savneet knew that though this was true, there were other less obvious consequences. Greater mileage meant more frequent repairs on the rental cars and lower resale value after the car was a year old. Unfortunately, Savneet was not convinced that the increased revenue from customers would be enough to offset these additional costs and loss of revenue.

            But before Savneet would go to her supervisor with these concerns, she needed to make sure that mileage on the cars was in fact, on average, going up. This is why she got Noor to send her this Excel file. It was a random sample of 30 car rentals from each month in 2016 (see the Excel file). Savneet felt that it was a good representation of what the population of mileage of all car rentals from 2016.

            In addition to the data provided by Noor from 2016, Savneet also had a more recent random sample of the mileage of 20 car rentals from last month. This sample had a mean of 184.1 km with a standard deviation of 75.2 km.

            As she stared at her screen, a plan formed in her head. For her analysis, Savneet would first use the data from Noor as her parent sample. Then she would create a sampling distribution from the parent sample. Once she had her sampling distribution, she would determine the probability she would get a sample mean of 184.1 km (from her recent sample), under the assumption that the average mileage of car rentals had not changed. This probability would help her determine if something had changed or not.

Answer the following questions to help Savneet do her analysis.

NOTE: There are two samples described above: a sample from 2016 and a recent sample.

  • The random sample from 2016 (i.e. the parent sample) is provided in the Excel sheet.
  • The actual data for the recent random sample of size 20 is not provided. Only the summary information of a mean of 184.1 km and a standard deviation of 75.2 km is provided.

Question

  1. Describe, in your own words, the process for creating the sampling distribution of sample means Savneet would need to find. Make sure you use the context in your answer. (5 marks)

Solutions

Expert Solution

Savneet has a sample provided by Noor containing 30 car rentals from each month in 2016 i.e., this sample describe the car rentals of 2016. We can do Exploratory Data Analysis (calculate mean, standard deviation, variance, etc. and plot histogram, etc.) to understand the distribution of the 30 data points.

Savneet also has the summary statistics, Mean of mileage = 184.1 km and standard deviation of mileage= 75.2 km for a recent sample of 20 car rentals.

Now, to check if there is any average increase in mileage, Savneet is assuming that average mileage for car rentals has not changed i.e., the mean and standard deviation of a sample of 30 car rentals should be equal to the mean and standard deviation of the recent sample,contaning 20 car rentals.

Null hypothesis:

Ho : The average mileage of car rentals is 184.1 km and standard deviation is 75.2 km

H1 : The average mileage of car rentals is not 184.1 km and standard deviation is not 75.2 km

Also, now to validate the hypothesis testing for 30 car rentals sample data.

We will do so by calculating Mean, standard deviation and plotting histogram of various sample means from 30 points sample. This is called Sampling Distribution of sample Mean.

Procedure:

1. First, we will draw 10 samples each of size 10 data points from 30 points sample with replacement. Here, n = 10 will be able to exhaust all possible data points in sample with low bias and size = 10 will be able to explain good variability in the data.

2. We calculate means of these 10 samples, 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 and 10.

3. Now these 10 mean points become another sample and we work on finding their distribution by calculation mean, standard deviation and plotting histogram of these 10 mean points.

This is called the sampling distribution of sample means.

Now, Savneet can find and check if, mean =  

and we can calculate standard deviation for these 10 points.

Then, Savneet will compare this mean and standard deviation with 184.1 km and 75.2 km to see and increase in average mileage.

This procedure is more reliable, less bias and has less variability. Therefore, becomes ideal for the use.


Related Solutions

Jane Smith complained to her doctor that she was always tired and that she had bleeding...
Jane Smith complained to her doctor that she was always tired and that she had bleeding from her gums. Blood tests showed decreased platelet counts, increased atypical lymphocytes and presence of the Philadelphia chromosome. What disease is Jane Smith likely to have and what treatment should she get?
Answer the following problems in an Excel file. Please upload only one Excel file with all...
Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation rather than a calculation). All problems must be solved using the PV and FV functions in Excel. If I deposit $8,000 in a bank account that pays interest of 1.5%, compounded annually, how much will I have in the account after 10 years? If I deposit $8,000 in a bank account that pays simple interest...
Barbara Young had great expectations about her future as she sat in her graduation ceremony in...
Barbara Young had great expectations about her future as she sat in her graduation ceremony in May 2013. She was about to receive her Master of Accountancy degree, and next week she would begin her career on the audit staff of Greene, Sims, and & Co., CPAs. Things looked a little different to Barbara in February 2014. She was working on the audit of Dee-Dee Fashion Fabrics, a textile manufacturer with a calendar year-end. The pressure was enormous. Everyone on...
Nurse Victoria Munoz has been reading leadership theory. She had hoped to be inspired by this...
Nurse Victoria Munoz has been reading leadership theory. She had hoped to be inspired by this new knowledge and discover better ways to solve some problems in the nursing work environment. Instead, Nurse Munoz is puzzled. The real work environment is dramatically different from what the theory says it should be. Many articles call for strong, motivating leadership in nursing with shared leadership and empowerment of staff nurses. However, in the health care environment in which Nurse Munoz works, nursing...
The patient alleged that the defendant physician fraudulently and negligently advised her that she had a...
The patient alleged that the defendant physician fraudulently and negligently advised her that she had a brain tumor that required immediate surgery, that the physician negligently performed an unneeded craniotomy on her at the hospital, and the physician had held staff surgical privileges at the hospital on a continuing basis. The plaintiff patient further alleged several theories against hospital. Underlying these was the contention that the hospital had sufficient prior information to be put on notice that the defendant physician...
Leshonda had been working at her job for almost twenty years. She felt like she worked...
Leshonda had been working at her job for almost twenty years. She felt like she worked overtime more often than not and deserved a raise, so she randomly selected 50 paychecks and found that she had worked overtime in 32 of those weeks. Use a TI-83, TI-83 plus, or TI-84 calculator to test whether Leshonda worked overtime more often than not. Identify the p-value, rounding to three decimal places. PLEASE SHOW ON THE STEPS ON THE CALCULATOR, THANK YOU!
Shondra tells her doctor that she has been feeling jittery and has had trouble sleeping. She...
Shondra tells her doctor that she has been feeling jittery and has had trouble sleeping. She also complains about her roommates changing the thermostat and making it too high. A blood test shows antibodies and suggests she might have an autoimmune disease. What organ do you think the antibodies are binding to and how might this cause her symptoms?
Question Allison Boone had been practicing medicine for seven years. Her specialty was neurology. She had...
Question Allison Boone had been practicing medicine for seven years. Her specialty was neurology. She had received her bachelor’s degree in chemistry from Kent State University and her M.D. from Washington University in St. Louis. She did her residency at Columbia Presbyterian Hospital in New York. Allison practiced neurology in a clinic with three other doctors in Hurst, Texas. Her husband, Samual L. Boone, held an administrative position for Harris Methodist HMO in Arlington, Texas. Allison and Samuel had been...
Please create an Excel file with the calculated answers to the questions to the Excel homework...
Please create an Excel file with the calculated answers to the questions to the Excel homework for this week. The questions are listed in the attached PDF file.   Please also go over the Excel file attached to this assignment in order to familiarize yourself with the different ways Excel can be used to solve Time Value of Money problems when multiple cash flows are involved. There are three worksheets in the Excel file. This Excel file with examples is just...
Cara had been over her resume again and again. She was sure it was right. The...
Cara had been over her resume again and again. She was sure it was right. The night before the interview, she printed out a few copies to take with her. She looked this version so it would be fresh in her mind. Suddenly she noticed that she had made two errors! She had misspelled the company name with an ie rather than an ei, and she had used too instead of to. She quickly fixed both mistakes and was thankful...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT