using excel or python or SPSS ). Open thenc.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.

A pivot chart using the variablesweightandhabit.

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.