(using excel or python or SPSS ). Open the nc.csvdataset, a dataset of 1,000 randomly sampled births from the birth records released by the state of North Carolina in 2004. download the dataset and read its description at the following link, then answer the questions:https://www.openintro.org/book/statdata/index.php?data=nc

For the visualizations, paste a picture of your visuals into this document using Microsoft's snipping tool or other screen capture tool.

1. Calculate the following statistics for the variable weeks:
   1. Number of missing variables:
   2. Mean:
   3. Median:
   4. Mode:
   5. Sample Standard Deviation:
   6. Sample Variance:

1. A scatterplot visualizing the relationship between the variables weeks and weight and interpret the visualization to describe the relationship between the two variables.

1. A box-and-whisker chart using the variable weight.According to the box plot, what is the median for weight ? According to the box plot, are there more outliers to the high side or low side of the whiskers ?

1. a bar chart depicting the average weight of the babies considering the mature variable using the default axis

Change the axis for weight so the minimum weight value on the axis is 5 and the maximum weight value on the axis is 10 .

How does altering the axis for weight change the visual interpretation of the mature variable in relation to weight

What is the average weight of babies for mature moms?

What is the average weight of the babies for younger moms?

1. A pivot chart using the variables weight and habit.

Using the chart, answer the following questions:

1. Number of missing values : ____________________
2. Count of babies whose birth weight is low and whose mother is a non-smoker: ____________________
3. Count of babies whose birth weight is low and whose mother is a smoker: ____________________
4. Count of babies whose birth weight is not low and whose mother is a non-smoker: ____________________
5. Count of babies whose birth weight is not low and whose mother is a smoker: ____________________
6. Looking at the above responses, do you think smoking has any impact on the birth weight of babies? Explain your reasoning.

1. Looking at the histogram and box plots below, answer the following two questions.