ASHFORD BUS 308 Week 5 Final Part II Analysis Paper on gas prices (Old)
For more course tutorials visit
www.tutorialrank.com
Tutorial Purchased: 3 Times, Rating: A
Imagine that you are a manager at a delivery service and you are creating a report toproject the effects on your company of rising gas prices in the next ten years.
Using thepreceding statistical analysis as your basis and outside scholarly resources to support yourclaims,
write a 3 to 5 page paper interpreting the results from this perspective. Include thefollowing considerations:
1. Introduce the project and its significance to the company.
2. Explain the statistical analysis that you completed in Part I. Be sure to explain wherethe data came from, what analysis was done, and what the results were.
3. Give conclusions that you have drawn from the data. Consider the effects of your gasprice predictions on the delivery business. Also consider whether or not you believe yourpredicted gas prices are accurate. What could occur in the future that would change yourlinear regression line and therefore your prediction?
__________________________________________________________________________________________________
ASHFORD BUS 308 Week 5 Final Part I – Excel (Old)
For more course tutorials visit
www.tutorialrank.com
Tutorial Purchased: 2 Times, Rating: A
Calculate the mean yearly value using the average gas prices by month found in the"Final Project Data Set".
2.Using the years as your x-axis and the annual mean as your y-axis, create a scatterplotand a linear regression line.
3.Answer the following questions using your scatterplot and linear regression line:* What is the slope of the linear regression line?* What is the Y-intercept of the linear regression line?*
What is the equation of the linear regression line, in slope-intercept form?* Based on the linear regression line,
what would be an estimated cost of gas in the year2020?* What are the...