EXCEL DATA ANALYSIS! PROJECT STATISTICS

Learning Objectives:

1. Use excel to calculate descriptive statistics for a given data set and to interpret those statistics

2. Use Excel to create confidence intervals around random variables

3. Develop research questions and hypotheses

4. Conduct hypothesis tests for variables of interest

Directions:

Step 1: Familiarize yourself with the data

For this assignment, a dataset has been provided for students from the Bureau of Economic and Business

Step 2: write a professional report/analyze data

1. (2 points) A cover page containing:

1.1. The title “An Analysis of Florida Tourism”

1.2. Your full name(s)

1.3. The course information

2. (6 points) A brief 1 paragraph summary of the data (based on your forthcoming analysis)

2.1. What kind of data do you have? Primary or Secondary, cross-sectional or time series, local or global scale, continuous or discrete, etc.

2.2. What kind of analysis did you do?

2.3. Summary of some interesting findings (based on forthcoming analysis)

3. For each variable in the data set:

3.1. (7 points) Generate descriptive statistics using the data analysis toolpack

3.2. (14 points) Generate a 95% confidence interval for each variable

3.3. (21 points—3 points each) Test the following hypotheses (show all the steps and clearly state your conclusions):

3.3.1. Florida topped 60 million visitors for the first half of 2017 implying that if that trend continues then there will be 120 million visitors this year. Has the number of tourists to Florida been greater this year than normal?

3.3.2. Someone tells you that right after Hurricane Irma, the vacancy rate in Florida was around 8% (due to people staying in hotels as their homes sustained damage). Is this vacancy lower than normal?

3.3.3. Watercraft injuries in 2017 were well publicized but only around 150 injuries were sustained. Were 2017 watercraft injuries significantly higher than in years passed (2000-2015 to be precise)?

3.3.4. Criminal activity in Florida this year has been around 1,000,000 incidents. Is this higher than normal?

3.3.5. The “Mothers Against Drunk Drivers” group claims that their efforts have been successful at bringing down the number of Florida alcohol related crashes down to 18,336 in 2017. Does this represent a statistical decrease of alcohol related crashes if their estimate is accurate?

3.3.6. The national median age was 37.8 years of age in 2015. Is it true that Florida is a geriatric state full of retirees (e.g. FL residents are older than the nation)?

3.3.7. Many cite the CSI in Florida at 95 as an indicator of a robust economy. Is this year’s CSI significantly higher than normal?

2