Excel Statistics Concepts Assignment

Due Sunday by $11$:$59pm,$ Points $10$ Submitting a file upload

File Types doc, docx, pdf$,x|s|,$ and $x|sx|$

You have been given data on height and weight of NBA basketball players: $NB{A}_{W}eigh{t}_{D}at{a}_S$tudent.xIsx ${?}_{(})darr$

Save the file as "Last$\_$First$\_$ExcelStatistics.xIsx". Create a new tab called "working data" and place the Master tab information here. This should prevent you from deleting or altering the core master data tab.

Your job is to complete an analysis similar to the ones seen in lecture by answering the below $10$ questions. The data is not in analyzable format yet as you need to create dummy variables in order to complete a regression using categorical variables..

You will export your results of the various tests$/$analyses to a word document and submit the word document for grading. You will do this by copying and pasting the statistical result output and pasting it as an image into a word document. Please $m$ ke sure you paste the image such that all of the results are visible. You may need to resize the image or copy a portion of the excel workbook for this to work properly. You will also need to have your excel sheet available if the instructor requests it$.$ Please place each numbered item in its own worksheet.

As part of your deliverable you must submit answers to the following:

Are there duplicates in this dataset? Why or why not? Discuss the data you are given.

Run descriptive statistics for height and weight for the entire data set.

Create a histogram for each, height and weight, to check for normality. $($Remove the legend and give your histogram a title for the variable it is charting$)$ Are the heights and weights normally distributed? What could we do to this data to try and make it more normal if it isn't already?

Apply a z$-$score correctly and find the $x$ value needed to be in the $90$ th percentile of the distribution for