Create a Microsoft Excel spreadsheet with the two variables from your learning team’s datasetCreate a Microsoft Excel spreadsheet with the two variables from your learning team’s dataset.

Analyze the data with Microsoft® Excel® or other statistical tool(s), including:

Descriptive stats for each numeric variable

Histogram for each numeric variable

Bar chart for each attribute (non numeric) variable

Scatter plot if the data contains two numeric variables

Determine the appropriate descriptive statistics.

For normally distributed data use the mean and standard deviation.

For significantly skewed data use the median and interquartile range.

Use the Individual Methodology Findings Template to complete the descriptive statistics
For this research project, the model vehicle was the qualitative independent variable (IV), while the emission percentage from the different type of cars was the quantitative dependent variable (DV).

Based on the business dilemma identified by the stakeholder, the research question for this study was:

RQ: Are all Jeetle models emitting excessive CO2emissions than Maudi models?

Based on this research question, the hypotheses for the study were:

HO: Are all Jeetle models exceedingCO2emissions standards based on the Maudi model.

HA: All Jeetle models are not exceeding CO2emission standards based on the Maudi model

Create a Microsoft Excel spreadsheet with the two variables from your learning team’s datasetCreate a Microsoft Excel spreadsheet with the two variables from your learning team’s dataset.

Analyze the data with Microsoft® Excel® or other statistical tool(s), including:

Descriptive stats for each numeric variable

Histogram for each numeric variable

Bar chart for each attribute (non numeric) variable

Scatter plot if the data contains two numeric variables

Determine the appropriate descriptive statistics.

For normally distributed data use the mean and standard deviation.

For significantly skewed data use the median and interquartile range.

Use the Individual Methodology Findings Template to complete the descriptive statistics
For this research project, the model vehicle was the qualitative independent variable (IV), while the emission percentage from the different type of cars was the quantitative dependent variable (DV).

Based on the business dilemma identified by the stakeholder, the research question for this study was:

RQ: Are all Jeetle models emitting excessive CO2emissions than Maudi models?

Based on this research question, the hypotheses for the study were:

HO: Are all Jeetle models exceedingCO2emissions standards based on the Maudi model.

HA: All Jeetle models are not exceeding CO2emission standards based on the Maudi model