Statistical report help needed. Feedback given on report as followed.

Why is the t-test appropriate? Provide a little more detail. Also, what assumptions do you make about this data, and what happens if these assumptions are not true?

Guide line information as follows

The final project will be a

Statistical Report that will include the solution data. Be sure to consider a

statistical analysis project that applies to a real-life problem or situation.

You may need to collect additional data as the course progresses as you will

want to complete analysis associated with the content covered in this course.

A comprehensive report must

include the following elements:

1. Statistical Report

An overall description of the

study

The data and the means of

collection

The statistical methodology

used for analysis of the data

A summary of the results

2. The Solution Data

The problem statement

The analyst statement

The solution data inputs and

outputs

Paper Submitted information as followed

The purpose of this statistical report is to analyze the unemployment rate in North Carolina compared to Texas for the 2019.

Month/Year NC % National % Jan-19 4.50% 4.00% Feb-19 4.20% 3.80% Mar-19 4.10% 3.80% Apr-19 3.50% 3.60% May-19 3.90% 3.60% Jun-19 4.20% 3.70% Jul-19 4.30% 3.60% Aug-19 4.10% 3.70% Sep-19 3.40% 3.50% Oct-19 3.50% 3.60% Nov-19 3.50% 3.50% Dec-19 3.30% 3.50% Texas: Month/Year TX % National % Jan-19 4.10% 4.00% Feb-19 3.70% 3.80% Mar-19 3.50% 3.80% Apr-19 3.00% 3.60% May-19 3.10% 3.60% Jun-19 3.70% 3.70% Jul-19 3.80% 3.60% Aug-19 3.70% 3.70% Sep-19 3.40% 3.50% Oct-19 3.30% 3.60% Nov-19 3.40% 3.50% Dec-19 3.30% 3.50%

1. Problem statement:The purpose of this statistical report is to analyze the unemployment rate in North Carolina compared to Texas for 2019.

Description of the study: The purpose of the study is to check the unemployment rate in North Carolina compared to Texas for 2019.To compare the mean difference between the unemployment rate in NC and TX, the t test is appropriate.

Mean of NC % is 3.875

Mean of TX % is 3.5.

Data: Data is collected in 2019. The data contains unemployment rates in North Carolina and Texas. The data was collected monthly for NC and TX percentage.

2. Statistical methods: Two sample t tests areused to compare the mean difference in unemployment rates between TX and NC. Using the T test, there is a significant difference between the unemployment rate in NC and TX. That is, the unemployment rate in NC and TX is not the same.

Explanation:

1.

Problem statement:

The purpose of this statistical report is to analyze the unemployment rate in North Carolina compared to Texas for 2019.

Here we need to check whether the unemployment rates of NC and TX are the same or not. The two sample t-test is used to test whether the population means of two different groups are equal or not if their population standard deviation is unknown. For the given scenario population, the standard deviation of unemployment rate is unknown, hence the two sample t test for equality of mean is used.

Description of the study: The purpose of the study is to check the unemployment rate in North Carolina compared to Texas for 2019.To compare the mean difference between the unemployment rates in NC and TX, the t test is appropriate.

Mean of NC % is 3.875

Mean of TX % is 3.5.

Data: Data is collected in 2019. The data contains unemployment rates in North Carolina and Texas. The data was collected monthly for NC and TX percentage.

Statistical methods:

• Descriptive statistics was done here

Here we found he standard deviation of NC is 0.4414.

The standard deviation of TX is 0.3133.

There is less variation in the TX unemployment rate as compared to NC unemployment rate.

The negative value of the kurtosis indicates the distribution of NC and TX is flat.

NC is positively skewed and TX is negatively skewed.

Next we did a two sample t test

Hypothesis

H0: The unemployment rate in NC and TX is the same.

H1: The unemployment rate in NC and TX is not the same.

Data entered into Excel

We found

Test result: P value=0.02026

The P value is less than 0.05, thus rejecting H0. There is a significant difference between the unemployment rates in NC and TX.

2.

The t test is used to compare the mean difference in unemployment rates between TX and NC. Using the T test, there is a significant difference between the unemployment rate in NC and TX. That is, the unemployment rate in NC and TX is not the same.

From the feed back the professor is asking Why is the t-test appropriate? Provide a little more detail. Also, what assumptions do you make about this data, and what happens if these assumptions are not true?

I'm needing a little help on what else to add.