The company you work for processes and uses crude oil. In order to predict the price of production in the future, your manager wants you to analyze the historical price of crude oil. In looking at potential patterns, your company can use this information to help plan for the future.
(Use the following crude oil prices data below for the assignment)
Crude Oil Prices (in US dollars)Jan201627.02Feb201625.52Mar201631.87Apr201635.59May201641.02June201643.96July201640.71Aug201640.46Sept201640.55Oct201645.00Nov201641.65Dec201647.12Jan201748.19Feb201749.41Mar201746.39Apr201747.23May201745.19June201742.19July201743.42Aug201744.96Sept201747.17Oct201749.13Nov201755.19Dec201756.98
Enter the data above in an Excel spreadsheet, place it on the first worksheet and label the worksheet “CrudeOilPriceData”. Create two additional worksheets, labeled “PolyTrend” and “ExpTrend”. On the “PolyTrend” worksheet, create an line chart from the data to illustrate the information graphically. On the “ExpTrend” worksheet, create a XY chart from the data (all data should be on one chart) to illustrate the information graphically. Ensure that your charts are labeled with a title and legends for the x and y-axis. Use three different orders of polynomials (not just 3rd order polynomials) in creating trend lines on the “PolyTrend” worksheet. On the “ExpTrend worksheet, create an exponential trend line. The equation of the trendline and the R-squared value are required for all trendlines on all charts as well. Remember to make the information on the chart and graphs look presentable and professional.
Text Size: All of the main text in this assignment needs to be set in 10 or 12-point size. Please resist the temptation to mix and match point sizes. If you doubt your applications intentions, just select all of your text and insure that it is in 10 or 12-point size. Your titles, legends and labels can be different sizes.
Margins: The right and left side can be set for ½” (0.5) margins. Set the top and bottom margins to one (1”). The only text that ends up on the outside of the one-inch margin is the page number.
Name Block: Place the name block in the upper left corner of the page. In MS Excel, use the left side cells. In this class, the name block only needs to be on the first page/first worksheet. Put your name first, then the class title and then the duedate.
Title: All homework assignments have a title. For all Excel-based assignments, skip one cell and place the title on the left, just below the name block. The title for this assignment is “Homework 2”.
Spelling/Grammar Checking: Remember to do your spelling and grammar checking before turning your assignments in. When doing the spelling/grammar checking keep in mind that some words such as mush and must, woods and words, or here and cow, will not be caught by either check. To correct these problems, you will need to proofread your work.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more