Select a current price that you have seen or paid recently

Assignment Help Accounting Basics

Reference no: EM13590923

To complete the following assignment, go to this week's Final Project link in the left navigation.
Focus of the Final Project
To complete this project, use the "Final Project Data Set" found in your eCollege classroom in the Final Project description.

PART I:

Calculate the mean yearly value using the average gas prices by month found in the "Final Project Data Set."
Using the years as your x-axis and the annual mean as your y-axis, create a scatterplot and a linear regression line.
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 year 2020?
What are the residuals of each year?
Select a current price that you have seen or paid recently for gas. Is that price within the range of the linear regression line or is it an outlier? Is it within the confidence interval of 5% or either end?
PART II:

Imagine that you are a manager at a delivery service and you are creating a report to project the effects on your company of rising gas prices in the next ten years. Using the preceding statistical analysis as your basis and outside scholarly resources to support your claims, write a 3 to 5 page paper interpreting the results from this perspective. Include the following considerations:

Introduce the project and its significance to the company.
Explain the statistical analysis that you completed in Part I. Be sure to explain where the data came from, what analysis was done, and what the results were.
Give conclusions that you have drawn from the data. Consider the effects of your gas price predictions on the delivery business. Also consider whether or not you believe your predicted gas prices are accurate. What could occur in the future that would change your linear regression line and therefore your prediction?
Writing the Final Project

The Final Project:

Part I must be provided as an Excel spreadsheet. It must be complete and show all work, not just a final amount or answer
Part II must be 3 to 5 double-spaced pages in length, and formatted according to APA style as outlined in the Ashford Writing Center
Must include a title page with the following:
a. Title of paper
b. Student's name
c. Course name and number
d. Instructor's name
e. Date submitted

Must include an introductory paragraph with a succinct thesis statement
Must address the topic of the paper with critical thought
Must conclude with a restatement of the thesis and a conclusion paragraph
Must use at least 3 scholarly resources, including a minimum of 2 from the Ashford Online Library
Must document all sources in APA style, as outlined in the Ashford Writing Center
Must include a separate reference page, formatted according to APA style as outlined in the Ashford Writing Center

Reference no: EM13590923

Questions Cloud

What is the ratio of the maximum radial force on the : the spin cycles of a washing machine have two angular speeds 423 revmin and 640 rev min. the internal diameter of the

Vinita ramaswamy recently acquired wild country air wild : vinita ramaswamy recently acquired wild country air. wild country has been in business for many years and provides

Our sun is 23 x 104 ly light-years from the center of our : our sun is 2.3 x 104 ly light-years from the center of our milky way galaxy and is moving in a circle around that

Joyce is a single cash-method taxpayer on april 11 2009 : joyce is a single cash-method taxpayer. on april 11 2009 joyce paid 120 with her 2008 state income tax return.during

Select a current price that you have seen or paid recently : to complete the following assignment go to this weeks final project link in the left navigation. focus of the final

You are in a job interview and your possible employer asks : you are in a job interview and your possible employer asks you to describe the differences between the flexible and the

A car starts from rest and moves around a circular track of : question a car starts from rest and moves around a circular track of radius 30.0 m. its speed increases at the constant

A girl has a 2000 overdue debt for books the local : a girl has a 2000 overdue debt for books the local bookstore. she has only 600 in her checking account. the bookstore

On october 1 2012 joy co issued 500 five-year bonds with a : on october 1 2012 joy co. issued 500 five-year bonds with a face value of 1000 each and a stated interest rate of 6

User Account

All Pages