Hello you could help me I would like to know how to do the trendline on excel and how to insert the forumula in the chart

Thank you,

Helen

Is it ok if I use box.com I will respond to you in about 2 hrs I have to do something?

Okay here is part 1 of it https://www.box.com/s/7032ef8d587c162cdc69

and here are the questions that go with it questions

PART I:

1. 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 scatterplot and 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 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?
Here is what I did so far

https://www.box.com/s/d07ee366b93b43ba02d3

I will contact you in 2 hours

Thank you,

Helen

Hello it is in a excel file.

The first one is an excel file. You have to download it.

Ok could you look at the information and try to solve th problem and look at what I did on the excel.

Thank you,

Helen

Hello I will send you part 2 of the questions that pertains to the excel project.

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:

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 where the 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 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:

1. Part I must be provided as an
   Excel spreadsheet. It must be complete and show all work, not just a final
   amount or answer
   
2. 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
   
3. 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
   
4. Must include an introductory
   paragraph with a succinct thesis statement
   
5. Must address the topic of the
   paper with critical thought
   
6. Must conclude with a restatement
   of the thesis and a conclusion paragraph
   
7. Must use at least 3 scholarly
   resources, including a minimum of 2 from the Ashford Online Library
   
8. Must document all sources in APA
   style, as outlined in the Ashford Writing Center
   
9. Must include a separate reference
   page, formatted according to APA style as outlined in the Ashford Writing
   Center.

Yes that is ok. Please do.