Reference no: EM132245095
Assignment : An Analysis of Florida Tourism
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. Discuss probability for normal distributions
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 Research.
Step 2: write a professional report/analyze data
1. 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. For each variable in the data set:
2.1. Generate descriptive statistics using the data analysis toolpack
2.2. Generate a 95% confidence interval for each variable (year is the element, not a variable) and economically interpret these intervals. For those variables with fewer than 30 data points, assume the t-distribution. For greater than 30 data points, assume the z-distribution.
3. Tell an economic story about the variables included in this data set referencing the following questions. For these questions assume the standard normal distribution.
3.1. What is the probability of tourism being fewer than 60 million visitors?
3.2. What is the probability of rental vacancy being more than 10%?
3.3. What is the probability of watercraft injuries in Florida exceeding 200 incidents?
3.4. What is the probability that there will be more than 1 million crimes in Florida?
3.5. What is the probability that alcohol related crashes will remain below 20,000 incidents?
3.6. What is the probability of the Florida residents median age being over 40 years of age?
3.7. What is the probability of the Florida Sentiment index being between 95 and 100?
Attachment:- Tourism Data.rar