Using Ideal Weight data, make a histogram, get Mean, Std.Deviation, and Five-Number Summary
a. Using Ideal Weight data, make a histogram, get Mean, Std.Deviation, and Five-Number Summary. Describe the distribution.Description should include min, max, center, spread, number of peaks, shape, identification of outliersb. Calculate the z-score for the weight 170 lbs. What is the probability P of weighing more than 170 -- P(x>170) ?AgeGenderHeightWeightIdeal weight30F6011211530F6011411550F6311511048F6311511328F6311611041F6411611631F6412011031F6212011517F6812012546F6212111520F6012311531F6112313537F6312411858F6212511521F6512511038F6212512045F6212512126F6812512546F6012612022F6412711731F6312812047F6213011552F6213012021F6713012527F5613010520F6213011528F6213011522F6513212522F6513212522F6513212538F65.513312533F6713412533F6713412520F62.513512042F6613513028F6113511546F6213513026F6314012830M7114017519F6314213023F6814314336F6514412845F6714513240F6414512024F6514714045F6814814025F6414813825M7015017524F6015012026F6615012551F6215012022F7815017537M6915015066F6615014047F6715415027M7115516538F6815513026F6616015045F6316013043F6316012525M7016017545F7216014037M7416018535F6316113533F6416313023M6616415531M7216517525F7116515028F6716515028F6716515024M6716516039F6416514020M7116516525M7317018026M6817016046F6817214033F6717716055F6618015042F6318013543F7018015027F62181.812530M7318518038F7018517534M7318516530M7318518038M6718516544M6718716049M6918818550M6619018035M7319020033M7019017538F6919017026M7319018040M7119017533F6719115046M7319518046M7319518046M7319518025F6419814537F6920016531M6820017027M7620021530F6820017524M7520120036M6920418530M7320518029M7021020027M7221020033F6721018034F6821214051M6621519536M7421520522M7121519527M7221519541M7222019047M7322020026M7222020525M7222020038M7022018537M7122319025F6322517551M7522522537M7122619031M7422722045F6622715537F6923017532M7223020045M7023022029M7523518024F6423514035F6423516025M7323518035M7624020541M7624522029M7224822033F6425015046M7325022543M7425519038F6925515526M7026018039M7326022032M7526023028M7126020057M7427724049M7528524055M6829017529M73.530120533F6931015031M7141225044M70450180
10 years ago
Purchase the answer to view it

- using_ideal_weight_data_make_a_histogram_get_mean_std.deviation.xlsx