Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
What is the Laffer curve and what does it say about the relationship between tax rates and tax revenue? (4 points) For each state, do
- What is the Laffer curve and what does it say about the relationship between tax rates and tax revenue? (4 points)
For each state, do the following:
- Create a Per Capita Tax Revenue data column. (2 points)
- Create a scatter plot of the data. Click Insert -> Scatter. Choose the first scatter plot. Under Design, click Select Data -> Add. Plot Per Capita Tax Revenue on the horizontal axis and Tax Rate on the vertical axis. (3 points)
- Describe the relationship between these two variables. (8 points)
- Click Add Chart Element -> Trendline -> More Trendline Options -> Linear. You will now see a best fit line to the data which will estimate the relationship. See if any of the other possible trend line options would fit better. (2 points)
- Provide a descriptive statistics table with information on mean, median, standard deviation, minimum value, and maximum value for each of the variables. Go to Data Analysis. Select Descriptive Statistics. Select the input range for which you want to calculate the descriptive statistics. Make sure there is a check mark in the Labels in First Row Box and Summary Statistics box. Click OK. Explain what these values indicate. (Note: Answer in relation to the information you are examining, not in general. Use eac of the values generated.) (18 points)
- Conduct a correlation analysis between each variable pair. Go to Data Analysis. Select Correlation. Select the input range for which you want to calculate the correlation. Make sure there is a check mark in the Labels in First Row Box. Click OK. (4 points)
- Looking at the analysis from all four states, what conclusions can you draw concerning per capita tax revenue and tax rates? (4 points)
- Explain any difficulties or problems with the interpretation, manipulation, or reporting of the data involved in this dataset. (Note: This is not a critique of the homework assignment or the use of Excel. This is concerning questions the dataset and the results you found.) (5 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started