Instructions and materials will be provided in attachements1. Using the Accounting professionals...

Question

Instructions and materials will be provided in attachements

1. Using the Accounting professionals dataset and Rattle describe the data, use the cross tab to review two of the categorical variables. 2. Using the Atlanta Airline dataset and R-ggplot2 create and interpret graphics to understand the difference between schedule and actual Arrival times vs. Taxi-in time. 3. Using the Bicycle Inventory dataset and R, can you (using Diamonds example) represent in the same graphic the purchase cost, selling price and use color defined by product category? Create the histograms by selling price, use facets using two different variables. Please comment what you observe. 4. Using the Call Center dataset create a graphic that indicates how the relationships are between length of service and the other four variables. What can you observe? Use any tool/language that you want. 5. Using the Cell Phone Survey dataset and R - ggplot2 create the graphic of three pairwise variables of the three scores provided and separate them (facets) by carriers. Explain what you observe. 6. Using the Consumer Transportation Survey dataset and using RCmdr present the histograms for vehicle drive, type and satisfaction. Present, using R, the set of 3 by 3 scatter plots for reviewing three different variables vs. satisfaction. Please aggregate all outputs in a word document with all required graphs and explanations, remember the emphasis is not on coding and visualization, more importantly on how you interpret from the outputs, what stories can you create based on your observations? Please provide code script file as well

instructions-hfhyfk1g.docx

Aakarsh · Accepted Answer

Outputs
Outputs
Accounting Professionals
Summary of dataset
##     Employee       Gender          Years of Service
##  Min.   : 1.0   Length:27          Min.   : 5.0    
##  1st Qu.: 7.5   Class :character   1st Qu.: 8.0    
##  Median :14.0   Mode  :character   Median :10.0    
##  Mean   :14.0                      Mean   :14.7    
##  3rd Qu.:20.5                      3rd Qu.:20.5    
##  Max.   :27.0                      Max.   :31.0    
##  Years Undergraduate Study Graduate Degree?       CPA?          
##  Min.   :0.00              Length:27          Length:27         
##  1st Qu.:3.00              Class :character   Class :character  
##  Median :4.00              Mode  :character   Mode  :character  
##  Mean   :3.37                                                   
##  3rd Qu.:4.00                                                   
##  Max.   :4.00                                                   
##   Age Group        
##  Length:27         
##  Class :character  
##  Mode  :character  
##                    
##                    
## 
-> Accounting Professional data contains 27 employees data.
-> Total 7 variables out which 3 numerical and 4 categorical.
-> Undergraduate study years are 3 to 4 that is as per normal scenario."
Plots
## [1] "Frequency Plot of Age group"
-> Age group involved is maximum b/w 26-30 & 51-55.
-> According to histogram most of the people are with less years of service b/w 5 to 10.
Cross tabs to analyze categorical variables Gender, CPA, study graduate degree, Age Group
## [1] "Gender based Graduation %"
##    
##        N    Y
##   F 0.64 0.36
##   M 0.62 0.38
## [1] "Gender based CPA %"
##    
##        N    Y
##   F 0.43 0.57
##   M 0.54 0.46
## [1] "Gender based Age Group %"
##    
##     21-25 26-30 31-35 36-40 41-45 46-50 51-55
##   F  0.07  0.43  0.21  0.07  0.07  0.00  0.14
##   M  0.00  0.00  0.15  0.23  0.08  0.23  0.31
-> Graduation percentage is approximately similar in both genders.
-> Although more females are CPA certified than males.
-> Females are mostly younger i.e less than 35.
-> Men are more of middle-aged and above.
Results
-> Females are slightly more certified and educated in Accounting professionals.
-> Females working are younger while men are older.
-> Analyzing whole data vs Gender based results we found interesting and new insights.
Atlanta Airline
Summary of dataset
##  Flight Number  Origin Airport     Scheduled Arrival Time
##  Min.   :   8   Length:332         Length:332            
##  1st Qu.:1129   Class :character   Class :character      
##  Median :

1. Using the Accounting professionals dataset and Rattle describe the data, use the cross tab to review two of the categorical variables. 2. Using the Atlanta Airline dataset and R-ggplot2 create and...

Answer To: 1. Using the Accounting professionals dataset and Rattle describe the data, use the cross tab to...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment