Case - Sampling from DVD Movie Rentersampling From DVD Movie Renters (p. 334 in ), and review the Excel file C07_01.xlsx.
Based on the information presented, provide a summary discussing what form of sampling should be used to assess the data presented. Be sure to support your answer by showing the results generated through different testing methods used in Excel. Your write-up and test results should be submitted in one document. Copy information from Excel, and paste into Word. Submission should contain at least two scholarly references.
Book: Business Analytics: Data Analysis & Decision Making (5th Edition, Author: Albright)
Case:
The file C07_01.xlsx contains a large data set of 10,000 customer transactions for a fictional chain of video stores in the United States. Each row corresponds to a different customer and lists (1) a customer ID number (1 - 10,000), (2) the state where the customer lives, (3) the city where the customer lives, (4) the customer's gender, (5) the customer's favorite type of movie (drama, comedy, science fiction, or action), (6) the customer's next favorite type of movie, (7) the number of times the customer has rented movies in the past year, and (8) the total dollar amount the customer has spent on movie rentals during the past year.
The data are sorted by state, then city, then gender. We assume that this data set represents the entire population of customers for this video chain. (Of course, national chains would have significantly larger customer populations, but this data set is large enough to illustrate the ideas.)Imagine that only the data in columns A through D are readily available for this population.
The company is interested in summary statistics of the data in columns E through H, such as the percentage of customers whose favorite movie type is drama or the average amount spent annually per customer, but it will have to do some work to obtain the data in columns E through H for any particular customer. Therefore, the company wants to perform sampling. The question is: What form-simple random sampling, systematic sampling, stratified sampling, cluster sampling, or even some type of multistage sampling-is most appropriate?Your job is to investigate the possibilities and to write a report on your findings. For any sampling method, any sample size, and any quantity of interest (such as average dollar amount spent annually), you should be concerned with sampling cost and accuracy.
One way to judge the latter is to generate several random samples from a particular method and calculate the mean and standard deviation of your point estimates from these samples. For example, you might generate 10 systematic samples, calculate the average amount spent (an X ) for each sample, and then calculate the mean and standard deviation of these 10 X s. If your sampling method is accurate, the mean of the X s should be close to the population average, and the standard deviation should be small. By doing this for several sampling methods and possibly several sample sizes, you can experiment to see what is most cost-efficient for the company. You can make any reasonable assumptions about the cost of sampling with any particular method.
Need APA, written well, using 3 sources. I am requesting cheaper price because 1st assignment only got a B- grade. Instructor highly critiqued, saying missing good examples.
Attachment:- Copy of C07 01.xlsx