Question

One of our topics this week involves looking at continuous distributions, and recognizing the "Normal distribution" bell curve when it appears. The text also covers other types of common distributions we see as well.

These have also been covered in The Lady Tasting Tea - and we've done a LOT of histograms in this class because of this very week. NOW you see why we take so much time in constructing those histograms - they can show us the distribution of a data set in an easy to recognize format.

For this week's Excel assignment, I'm going to let you use any of the data sets we have practiced with so far in class. They're all fair game from the gradesPreview the document data, to moviesPreview the document, basketball statsPreview the document, LMAS animalsPreview the document, etc.

Turn in an Excel spreadsheet with at least FOUR examples of distributions covered in the text this week. Show their histograms, and explain why you think they fit that particular distribution type. Also include the descriptive statistics that back up what you see from the graphs, and tell how they support that finding - because we can't always rely on visual analysis alone, of course!

Why not? See the link I have posted about The Datasaurus Dozen!

One of our topics this week involves looking at continuous distributions, and recognizing the "Normal distribution" bell curve when it appears. The text also covers other types of common distributions we see as well.

These have also been covered in The Lady Tasting Tea - and we've done a LOT of histograms in this class because of this very week. NOW you see why we take so much time in constructing those histograms - they can show us the distribution of a data set in an easy to recognize format.

For this week's Excel assignment, I'm going to let you use any of the data sets we have practiced with so far in class. They're all fair game from the gradesPreview the document data, to moviesPreview the document, basketball statsPreview the document, LMAS animalsPreview the document, etc.

Turn in an Excel spreadsheet with at least FOUR examples of distributions covered in the text this week. Show their histograms, and explain why you think they fit that particular distribution type. Also include the descriptive statistics that back up what you see from the graphs, and tell how they support that finding - because we can't always rely on visual analysis alone, of course!

Why not? See the link I have posted about The Datasaurus Dozen!

           Data from Indiana Colleges      
                  
Name of Institution   Graduation Rate (%)   Salary After Attending ($)   Number of Students   Typical Total Debt ($)   Average Annual Cost ($)
Ancilla College   0.24   29200   398   20000   16395
Anderson University   0.57   35900   1862   27999   22654
Ball State University   0.58   39000   15985   25000   15294
Bethel College   0.63   36500   1579   21884   17730
Brown Mackie College - Fort Wayne   0.37   25200   659   21599   19133
Brown Mackie College - Merrillville   0.43   25200   619   21599   18575
Brown Mackie College - Michigan City   0.32   25200   290   21599   19178
Brown Mackie College - South Bend   0.38   25200   423   21599   19230
Butler University   0.73   52400   3998   26600   29103
Calumet College of St. Joseph   0.32   37200   988   24224   11517
College of Court Reporting Inc   0.31   23300   252   0   21106
Crossroads Bible College   0.61   26800   219   26951   15438
Depauw University   0.78   47800   2272   24500   22171
Earlham College   0.71   32300   1016   27000   19414
Franklin College   0.59   41000   969   27000   20438
Goshen College   0.71   36300   778   20857   19001
Grace College and Theological Seminary   0.6   33200   1286   22700   15799
Hanover College   0.69   44400   1159   27000   21002
Harrison College - Indianapolis   0.31   24700   3726   27167   19196
Holy Cross College   0.39   36300   490   25000   17637
Hunigton University   0.61   35500   1030   27000   19192
Indiana Institue of Technology   0.31   41100   5670   28744   21940
Indiana State University   0.43   36000   10173   24193   11864
Indiana University - Bloomington   0.76   45300   31984   23628   14174
Indiana University - East   0.25   29100   3132   23388   9011
Indiana University - Kokomo   0.25   33600   2708   19500   10921
Indiana University - Northwest   0.24   35900   4764   29037   13211
Indiana University - South Bend   0.25   33800   5538   25724   12068
Indiana University - Southeast   0.29   34000   5699   22915   11550
Indiana Wesleyan University   0.65   46000   10625   24807   25340
International Business College - Fort Wayne   0.73   27200   406   13625   17673
International Business College - Indianapolis   0.73   27200   399   13625   16346
IPFW   0.25   35900   9795   26000   14337
ITT Technical Institute - Fort Wayne   0.34   38400   283   25834   22119
ITT Technical Institute - Indianapolis   0.19   38400   4296   25834   23589
ITT Technical Institute - Newburgh   0.35   38400   295   25834   23921
IUPUI   0.4   39100   21569   25388   14666
Manchester University   0.53   38000   1188   27000   20151
Martin University   0.56   40400   2054   30090   19459
MedTech College - Fort Wayne   0.67   29300   357   20000   21736
MedTech College - Greenwood   0.5   29300   551   20000   21921
MedTech College - Indianapolis   0.5   29300   603   20000   21836
Mid-America College of Funeral Service   0.69   35400   63   17000   7585
Oakland City University   0.67   33700   587   17000   15629
Purdue University   0.7   52600   30167   23766   15543
Purdue University - Calumet   0.3   38100   7466   22781   12007
Purdue University - North Central   0.25   35200   3514   26000   9850
Rose-Hulman University   0.75   78900   2165   27000   33087
Saint Joesphs College   0.47   39800   1096   27000   25255
Saint Mary-of-the-Woods College   0.61   30200   630   27000   16466
Saint Mary's College   0.74   45600   1470   27000   24319
Taylor University   0.76   38600   1873   24713   19696
The Art Institute of Indianapolis   0.23   25200   862   21599   26323
Trine University   0.052   42600   1431   26063   21183
University of Evansville   0.66   40000   2373   26000   20396
University of Indianapolis   0.56   41600   4108   27450   22293
University of Notre Dame   0.95   69400   8466   21000   27845
University of Phoenix - Indianapolis   0.12   53400   338   35500   18704
University of Saint Francis   0.52   40000   1878   26000   16809
University of Southern Indiana   0.39   35500   8764   23275   14098
Valparasio University   0.72   48100   3209   27000   19952
Vincennes University   0.26   32200   8313   15599   10694
Wabash College   0.71   49900   896   23000   22723
                  
                  

Answer 1

used Excel above data and draw histogram and descriptive statistics for every variable