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?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Tourism-Data.rar