I decided to check the temperature difference between my current city and where I spent most of my teen/twenties. I came to find out that Appleton, WI is mildly colder during this time of the year than New York City, NY. In the past 11 days it was recorder that in Appleton the highest temperature at noon from September 18th to 28th was: 57, 64, 66, 72, 77, 81, 72, 77, 75, 61 and 55 (in Fahrenheit).Compared to New York City, NY, where the weather registered at:70, 63, 64, 64, 72, 79. 75, 77, 73, 79 and 70 (in Fahrenheit). This data was collected from https://www.timeanddate.com/weather/usa/appleton/historic. Due to the fact the data is accurate, in this case the level of confidence is at 98%.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Topic Video
Question

I decided to check the temperature difference between my current city and where I spent most of my teen/twenties. I came to find out that Appleton, WI is mildly colder during this time of the year than New York City, NY. In the past 11 days it was recorder that in Appleton the highest temperature at noon from September 18th to 28th was: 57, 64, 66, 72, 77, 81, 72, 77, 75, 61 and 55 (in Fahrenheit).Compared to New York City, NY, where the weather registered at:70, 63, 64, 64, 72, 79. 75, 77, 73, 79 and 70 (in Fahrenheit). This data was collected from https://www.timeanddate.com/weather/usa/appleton/historic. Due to the fact the data is accurate, in this case the level of confidence is at 98%. 

Expert Solution
Step 1

Null and alternate hypotheses:

The investigator is specifically interested to test whether there is any temperature difference in the current city Appleton and New York city or not.

Denote µ1 as the population mean temperature in the city Appleton and µ2 as the population mean temperature in the city New York.

Null hypothesis:

H0 : μ1 = μ2

That is, there is no significant difference between the mean temperature between the current city Appleton and New York city.

Alternative hypothesis:

H1 : μ1 ≠ μ2

That is, there is a significant difference between the mean temperature between the current city Appleton and New York city.

In order to test the hypothesis regarding the significant difference between the means of two independent samples, when the population standard deviations are unknown an independent sample t-test is appropriate.

EXCEL software can be used to perform two sample t test.

Software Procedure:

Step-by-step software procedure to perform a two sample t test using EXCEL software is as follows:

  • Open an EXCEL file.
  • Enter the data of Appleton in column A and name it as Appleton.
  • Enter the data of New York in column B and name them as New York.
  • Go to Data > Data Analysis > t – Test: Two-sample assuming equal variances.
  • Enter Variable 1 Range as $A$1:$A$12, enter Variable 2 Range as $B$1:$B$12.
  • Select Labels, and enter the Alpha as 02.
  • Click OK.

The output is shown below:

Statistics homework question answer, step 1, image 1

From the obtained output, the P-value corresponding to 2-tailed test is 0.4165.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Centre, Spread, and Shape of a Distribution
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman