Create a facet wrap bar chart that shows the Average Age

Assignment Help Applied Statistics

Reference no: EM132035672

R Programming Assignment -

Instructions: Please submit both R script and word document with final answers (where appropriate).

Question 1 - Download the seasonal_data.csv data set. Create an R script that addresses the following:

Show a table of average sales by month.

Show a table of average sales by year.

Show a table that lists all years, the month that contained the maximum sales amount for the entire year, and the corresponding amount.

Assume the following quarters: Q1 (Jan, Feb, Mar), Q2 (April, May, June), Q3 (July, Aug, Sep), and Q4 (Oct, Nov, Dec). Using data visualization to support your points, describe the variation in sales by quarter.

Question 2 - Download the bank_customers.csv data set. Create an R script that addresses the following:

Recode Education column from numeric to character where 1 represents "Undergrad," 2 represents "Graduate," and 3 represents "Advanced."

Make Education an ordered factor variable.

Create an Income_level column with "Low" representing below $50,000, "Medium" representing $50,000 - $150,000 inclusive and "High" representing above $150,000.

Create a facet wrap bar chart that shows the Average Age for each Income_level that is wrapped by Education.

Create a scatter plot of average spending on credit cards (CCAvg) vs. income. CCavg should be the y-variable while income should be the x-variable. Use different point colors to represent the varying levels of education.

Create 3 linear regression models of CCavg (y) vs. Income (x) for each level of education. Show the regression coefficients of each model.

What was the customer ID and corresponding residual value of the customer with the most overestimated CCavg?

What was the customer ID and corresponding residual value of the customer with the most underestimated CCavg?

How many customers had a predicted value within 10% (plus or minus) from their actual value?

Reference no: EM132035672

Questions Cloud

Calculate the npv of credit decision : Market research estimates that there is a 37% chance that BigBag will pay in full what it owes. Crisps uses a discount rate of 6.45% for all NPV analysis.

Write a description of the early childhood setting visited : Write a description, of the early childhood setting visited, that includes a profile of the children and families served in the program.

What is the npv to crisps of offering credit to bigbag : Based on this information, what is the NPV to Crisps of offering credit to BigBag?

Does amvac have a sustainable business strategy : Read the case of Amvac beginning of the text and consider the following questions in your post: Does Amvac have a sustainable business strategy? Why or why not?

Create a facet wrap bar chart that shows the Average Age : Create a facet wrap bar chart that shows the Average Age for each Income_level that is wrapped by Education. Make Education an ordered factor variable

How does the significance level : Hypothesis test clarification. How does the significance level, p value and Z/ t score relate in the bigger picture of hypothesis testing

What would you suggest the university do to expand revenue : Suppose that, in an attempt to raise more revenue, Nobody State University increases its tuition. Will this necessarily result in more revenue?

Game where there are two piles of chips : Consider a game where there are two piles of chips. On a player's turn, he may remove between 1 and 4 chips from the first pile or else remove

Different mean times to absorption assume equal std : test the claim that the two beans have different mean times to absorption assume equal std deviations

User Account

All Pages