For the following problem use Power BI and R-Studio. Use the former for visualizations and the latter for statistical analyses. You can also do this project in Excel but that will be graded out of a total of 5 points instead of 10.
An apparel store ran a promotion in which discount coupons were sent to customers of other National Clothing stores. Data collected for a sample of 100 in-store credit card transactions during one day while the promotion was running are contained in the attached file. The Proprietary Card method of payment refers to charges made using a National Clothing charge card. Customers who made a purchase using a discount coupon are referred to as promotional customers and customers who made a purchase but did not use a discount coupon are referred to as regular customers. Because the promotional coupons were not sent to regular stores customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make. The store also hopes that the promotional customers will continue to shop at its stores.
Most of the variables shown in the Table are self-explanatory, but two of the variables require some clarification.
Items
The total number of items purchased
Net Sales
The total amount ($) charged to the credit card
Management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.
Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign. At a minimum, your report should include the following:
Make different types of descriptive statistics using R. Choose relevant stats yourself.
Frequency distribution for key variables (see instructions at the bottom)
A bar chart or pie chart showing the number of customer purchases attributable to the method of payment (see instructions at the bottom)
Type of customer (regular or promotional) versus net sales. Support your answers with some of the followings: correlation, scatter plot, regression. Choose the relevant tests yourself.
A scatter diagram to explore the relationship between net sales and customer age.
High-quality visuals made in Power BI
Please note that your analysis should not be limited to the above points, but explore yourself which statistical tests/visuals may facilitate better understanding the problem and making better decisions.
Report format: A 5 pages professionally made report; with clear visuals, and snapshots from R-Studio. At least one paragraph at the end about your conclusions.
Useful syntax
For frequency distribution in R, use table function table (variable names); For bar graph use the above table as input –> barplot(above table)
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|