(using excel). 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.

This is link where the dataset is present https://www.openintro.org/book/statdata/index.php?data=nc

1. A pivot chart using the variableslowbirthweightandhabit.

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.

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