Question: Your task is to get to know the data by conducting some statistical analysis using BBBs customer database. Summary information about the BookBinders Book Clubs
Your task is to get to know the data by conducting some statistical analysis using BBBs customer database. Summary information about the BookBinders Book Clubs customers purchasing history and demographics is in the dataset called BBB.csv. Exhibit 1 (see above) contains a listing of the variable names and descriptions of the data types that you should use to answer the following questions: 1. What percent of BookBinders customers are female? 2. Which three states account for the largest percentage of BookBinderss customers? 3. What is the average Total $ spent, the average Total # of book purchases, and the average number of months since last purchase? 4. Calculate the correlation between customers total spending on books and their total spending on non-book products. 5. Which book categories have sold the most books? Which have sold the least? 6. Create a bar chart showing the average total spending on books for males and females. 7. For both males and females, find their respective total number and also the percent who bought The Art History of Florence. 8. For both males and females, determine the total number of purchases and the average number of purchases by males vs. females. 9. Determine the minimum, the maximum, and the average number of months between customers first purchase and their most recent purchase. 10. What percent of repeat customers (those with two or more total purchases) bought The Art History of Florence? 11. Create a word file that (1) copy and paste the 10 questions above, (2) below each question, copy and paste your code and output from R into the word file, (3) highlight the part of the output that answers the respective question,
please see this URL for data and case
https://drive.google.com/drive/folders/1PMHd_APOpeJH0UKUkPlSKtXP52wWN7GZ?usp=sharing
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
