Question
1.Refer to yearly sales data (yearly_sales.csv) to answer following questions via R commands a.Downloadtheyearly_sales.csvfromCanvasandimportittoR/RStudio.Saveittosales object. b.Check whether the imported CSV in the sales object is
1.Refer to yearly sales data (yearly_sales.csv) to answer following questions via R commands
a.Downloadthe"yearly_sales.csv"fromCanvasandimportittoR/RStudio.Saveittosales object.
b.Check whether the imported CSV in the sales object is data frame or not.
c.Display structure of the sales object.
d.Display the summary of this data set with the summary command.
e.Plot number of orders vs. sales.
f.Add a new column to the above data for average sales per order as total sales divided by number of orders to the rightmost via R command and submit the resultant CSV file.
g.Extract this new column (average sales per order) as a new variable and find the average of average sales per order.
h.Create new column categorizing the total sales into three groups/levels: small, medium andlargewithsmallaslessthan100,mediumasgreaterthanorequalto100andlessthan 500andbigasgreaterthanorequalto500.Namethisnewcolumnassales_group.
i.Build a contingency table based on the gender and the newly created sales_group column.
j.Find correlation and covariance between the total sales and number of orders.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started