Data Analytics film|Human Resource Management
Step 1. view the two videos below showing some introductory graphing in Tableau and R.
Step 2. prepare a table in a new powerpoint with 4 columns. In the first row, type in Tableau, R, Python, and D3 in the cells.
Step 3. Then, in the next several rows, type in the comparative (dis)advantages/capabilities of Tableau, R, Python, and D3 in there respective columns. To accomplish that task, search them in google. You could even using comparative statements – “R vs Python vs D3 visualization” etc. Use multiple sources in searching to minimize bias and errors potential.
Step 4. The answer the following questions below on the same powerpoint slide.
Q1. What surprised you (from what you learned)?
Q2. Which one do you think will be most useful in your jobs in the future and why?
Step 5. Open the pizza excel database you saved from exercise 9.
Step 6. Insert a scatterplot of taste + ph_fov (from the charts menu). Add a trendline (linear regression) [note: you right click on the data point on the scatterplot to get the option to add a trendline] and show the formula. Copy the scatterplot to a new slide in the powerpoint.
Step 7. prepare a chart that shows the average spending on each of the categories for the different cluster segments from your earlier cluster exercise that you saved on the pizza database. (Note: two stages = create a pivot table, use the values from the pivot table to create the bar chart). Adjust the axis min, max, etc., and the background color of the bars/columns. Copy the chart to the powerpoint.
Step 8. Save and upload the powerpointSheet1
taste coupon discount favorite flavor leave specials serve money occasion sports travel politics income famsize loyalty satisfy quality value ph_fov lc_fov nightoff gpv treat family spend
Mean 3.15 Mean 3.65 Mean 3.75 Mean 3.29 Mean 3.43 Mean 3.61 Mean 3.57 Mean 3.29 Mean 3.81 Mean 3.03 Mean 3.56 Mean 2.89 Mean 2.86 Mean 3.36 Mean 4.8 Mean 2.75 Mean 4.52 Mean 4.26 Mean 2.71 Mean 6.77 Mean 7.1 Mean 41 Mean 11.95 Mean 50.82 Mean 19.3 Mean 123.07
Standard Error 0.1610414339 Standard Error 0.1328590048 Standard Error 0.1572330189 Standard Error 0.1647127895 Standard Error 0.153250966 Standard Error 0.139185945 Standard Error 0.1451262077 Standard Error 0.1647127895 Standard Error 0.1236604997 Standard Error 0.1351803883 Standard Error 0.1365668519 Standard Error 0.1613672642 Standard Error 0.1463495194 Standard Error 0.1176538322 Standard Error 0.1302677895 Standard Error 0.1343709625 Standard Error 0.0559220236 Standard Error 0.069077617 Standard Error 0.0832363072 Standard Error 0.4004681604 Standard Error 0.5479991152 Standard Error 6.0079913112 Standard Error 0.9895795454 Standard Error 4.5937678468 Standard Error 1.3926575134 Standard Error 7.9874681517
Median 4 Median 4 Median 4.5 Median 4 Median 4 Median 4 Median 4 Median 4 Median 4 Median 4 Median 4 Median 3 Median 3 Median 4 Median 5 Median 3 Median 5 Median 4 Median 3 Median 6.5 Median 6 Median 15 Median 15 Median 55 Median 15 Median 117.5
Mode 5 Mode 4 Mode 5 Mode 5 Mode 5 Mode 4 Mode 4 Mode 5 Mode 5 Mode 4 Mode 4 Mode 1 Mode 1 Mode 4 Mode 4 Mode 4 Mode 5 Mode 4 Mode 3 Mode 3 Mode 6 Mode 0 Mode 15 Mode 0 Mode 15 Mode 55
Standard Deviation 1.6104143391 Standard Deviation 1.3285900478 Standard Deviation 1.5723301887 Standard Deviation 1.6471278952 Standard Deviation 1.5325096602 Standard Deviation 1.3918594495 Standard Deviation 1.451262077 Standard Deviation 1.6471278952 Standard Deviation 1.2366049972 Standard Deviation 1.3518038827 Standard Deviation 1.3656685195 Standard Deviation 1.6136726415 Standard Deviation 1.4634951936 Standard Deviation 1.1765383225 Standard Deviation 1.3026778946 Standard Deviation 1.3437096247 Standard Deviation 0.5592202363 Standard Deviation 0.6907761701 Standard Deviation 0.8323630715 Standard Deviation 4.0046816038 Standard Deviation 5.4799911524 Standard Deviation 60.0799131124 Standard Deviation 9.8957954545 Standard Deviation 45.937678468 Standard Deviation 13.9265751335 Standard Deviation 79.8746815172
Sample Variance 2.5934343434 Sample Variance 1.7651515152 Sample Variance 2.4722222222 Sample Variance 2.713030303 Sample Variance 2.3485858586 Sample Variance 1.9372727273 Sample Variance 2.1061616162 Sample Variance 2.713030303 Sample Variance 1.5291919192 Sample Variance 1.8273737374 Sample Variance 1.8650505051 Sample Variance 2.6039393939 Sample Variance 2.1418181818 Sample Variance 1.3842424242 Sample Variance 1.696969697 Sample Variance 1.8055555556 Sample Variance 0.3127272727 Sample Variance 0.4771717172 Sample Variance 0.6928282828 Sample Variance 16.0374747475 Sample Variance 30.0303030303 Sample Variance 3609.595959596 Sample Variance 97.9267676768 Sample Variance 2110.2703030303 Sample Variance 193.9494949495 Sample Variance 6379.9647474747
Kurtosis -1.675501983 Kurtosis -0.8412902317 Kurtosis -0.9737438405 Kurtosis -1.7386484929 Kurtosis -1.6552222645 Kurtosis -0.8405044098 Kurtosis -0.8963522101 Kurtosis -1.7386484929 Kurtosis -1.3054835868 Kurtosis -1.4611493876 Kurtosis -0.7636386418 Kurtosis -1.647621708 Kurtosis -1.3640884563 Kurtosis -0.673469079 Kurtosis 2.0588779589 Kurtosis -1.2949701256 Kurtosis -0.678386552 Kurtosis -0.8546119163 Kurtosis -0.4008935762 Kurtosis -0.6106683138 Kurtosis -0.6024885756 Kurtosis 0.4893652604 Kurtosis 1.3461192016 Kurtosis -1.5212002639 Kurtosis 0.0301676431 Kurtosis -0.6481579458
Skewness -0.1156823557 Skewness -0.7261753547 Skewness -0.8481794964 Skewness -0.159408502 Skewness -0.2087318278 Skewness -0.7594394991 Skewness -0.7690808854 Skewness -0.159408502 Skewness -0.5778843209 Skewness -0.130535389 Skewness -0.6869577293 Skewness 0.0054058576 Skewness 0.1293308182 Skewness -0.3966175025 Skewness 1.2756857141 Skewness 0.0366422007 Skewness -0.6104959277 Skewness -0.3941510132 Skewness -0.2660914029 Skewness 0.6383675063 Skewness 0.5516663115 Skewness 1.4593088417 Skewness 0.756970294 Skewness 0.210910556 Skewness 0.5107929458 Skewness 0.6443505528
Range 4 Range 4 Range 4 Range 4 Range 4 Range 4 Range 4 Range 4 Range 3 Range 4 Range 4 Range 4 Range 4 Range 4 Range 6 Range 4 Range 2 Range 2 Range 3 Range 16 Range 20 Range 200 Range 50 Range 135 Range 55 Range 305
Minimum 1 Minimum 1 Minimum 1 Minimum 1 Minimum 1 Minimum 1 Minimum 1 Minimum 1 Minimum 2 Minimum 1 Minimum 1 Minimum 1 Minimum 1 Minimum 1 Minimum 3 Minimum 1 Minimum 3 Minimum 3 Minimum 1 Minimum 1 Minimum 0 Minimum 0 Minimum 0 Minimum 0 Minimum 0 Minimum 15
Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 5 Maximum 9 Maximum 5 Maximum 5 Maximum 5 Maximum 4 Maximum 17 Maximum 20 Maximum 200 Maximum 50 Maximum 135 Maximum 55 Maximum 320
Sum 315 Sum 365 Sum 375 Sum 329 Sum 343 Sum 361 Sum 357 Sum 329 Sum 381 Sum 303 Sum 356 Sum 289 Sum 286 Sum 336 Sum 480 Sum 275 Sum 452 Sum 426 Sum 271 Sum 677 Sum 710 Sum 4100 Sum 1195 Sum 5082 Sum 1930 Sum 12307
Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100 Count 100
Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 9 Largest(1) 5 Largest(1) 5 Largest(1) 5 Largest(1) 4 Largest(1) 17 Largest(1) 20 Largest(1) 200 Largest(1) 50 Largest(1) 135 Largest(1) 55 Largest(1) 320
Smallest(1) 1 Smallest(1) 1 Smallest(1) 1 Smallest(1) 1 Smallest(1) 1 Smallest(1) 1 Smallest(1) 1 Smallest(1) 1 Smallest(1) 2 Smallest(1) 1 Smallest(1) 1 Smallest(1) 1 Smallest(1) 1 Smallest(1) 1 Smallest(1) 3 Smallest(1) 1 Smallest(1) 3 Smallest(1) 3 Smallest(1) 1 Smallest(1) 1 Smallest(1) 0 Smallest(1) 0 Smallest(1) 0 Smallest(1) 0 Smallest(1) 0 Smallest(1) 15
Confidence Level(95.0%) 0.3195411431 Confidence Level(95.0%) 0.2636210895 Confidence Level(95.0%) 0.3119844214 Confidence Level(95.0%) 0.3268259091 Confidence Level(95.0%) 0.3040831646 Confidence Level(95.0%) 0.2761751114 Confidence Level(95.0%) 0.2879618814 Confidence Level(95.0%) 0.3268259091 Confidence Level(95.0%) 0.2453692598 Confidence Level(95.0%) 0.2682272179 Confidence Level(95.0%) 0.2709782627 Confidence Level(95.0%) 0.320187661 Confidence Level(95.0%) 0.2903891972 Confidence Level(95.0%) 0.2334507284 Confidence Level(95.0%) 0.2584795561 Confidence Level(95.0%) 0.2666211415 Confidence Level(95.0%) 0.1109614273 Confidence Level(95.0%) 0.1370649786 Confidence Level(95.0%) 0.1651588916 Confidence Level(95.0%) 0.7946157124 Confidence Level(95.0%) 1.0873491339 Confidence Level(95.0%) 11.9211582048 Confidence Level(95.0%) 1.963540509 Confidence Level(95.0%) 9.1150320333 Confidence Level(95.0%) 2.7633346457 Confidence Level(95.0%)
