BUSI 2342 Course Project
\nDue Date: May 6th, 2022 11:59 PM
\nData Name:
\nCrude Oil Future, 2000 \u2013 2021 Monthly
\nNY Mercantile – NY Mercantile Delayed Price. Currency in USD
\nData source:
\nYahoo Finance: CL=F
\nThe instructions given below are an outline of the steps you need to take to complete your
\nproject ( help with nursing paper writing from experts with MSN & DNP degrees). They should be regarded as a guide and not a detailed map of the procedure. Further help
\non using Excel is available on for review with the project ( help with nursing paper writing from experts with MSN & DNP degrees) from Canvas and by clicking on the
\nExcel Help menu.
\nCase Description
\nCrude oil plays a vital role in the global economy. The price of oil affects government plans and
\nbusiness sectors. The ability to forecast crude oil prices can help companies and the government
\nbetter understand trends in energy economics and avoid potential risks. This study will show you
\nhow to use statistical methods to analyze and forecast crude oil prices in the past two decades.
\nNAME OF FIELD DESCRIPTION
\nDate Beginning date of each month
\nOpen Opening price of the month
\nHigh Highest price of the month
\nLow Lowest price of the month
\nClose Close price of the month
\nAdj Close Adjusted close price of the month
\nGuideline
\n1. You will need to have the data file for this project ( help with nursing paper writing from experts with MSN & DNP degrees) (ProjectData.xlsx) copied onto a disk
\nor flash drive. Click on the file to download and allow about a half minute for the
\ndownloading to be completed.
\n2. Open the Microsoft Excel.
\n3. Click on File Open, choose the address where the data file resides, and select the data file
\n(ProjectData.xlsx).
\n4. There are two sheets: \u201c2000-2014\u201d sheet includes monthly oil prices from the year 2000
\nto 2014, and \u201c2015-2021\u201d sheet includes monthly oil prices from the year 2015 to 2021.
\n5. The first few rows of the sheet \u201c2000-2014\u201d are shown below
\n6. The first few rows of the sheet \u201c2015-2021\u201d are shown below
\n7. Open a new sheet, rename it as \u201cPart A\u201d.
\n8. Go to sheet \u201c2000-2014\u201d. Copy the adjusted close price (Column F) for the sample of
\nyears 2000-2014 and paste these values into the sheet \u201cPart A\u201d. Rename the first row
\n(label) at the top of this new column to indicate what the values represent (e.g., Years
\n2000-2014).
\n9. Similarly, go to sheet \u201c2015-2021\u201d. Copy the adjusted close price (Column F) for the
\nsample of years 2015-2021 and paste these values into the sheet \u201cPart A\u201d, beginning at
\nthe second row. Rename the first row (label) at the top of this new column to indicate
\nwhat the values represent (e.g., Years 2015-2021).
\n10. The table below shows what the first ten lines in your two new columns should resemble.
\n11. Select the Data tab, then Click on Data Analysis (In Excel – Click on Data then Data
\nAnalysis).
\n12. Select \u201cDescriptive Statistics\u201d and click on OK.
\n13. Set the cursor in the Input Range box, and then highlight the columns A and B with year
\n2000-2014 and 2015-2021 data. Here, you can use the range \u201c$A$1:$B$148\u201d. Click the
\n\u201cLabels in first row\u201d box, and check the \u2018summary statistics\u2019 box. Click on OK.
\n14. Excel will then complete the descriptive statistics analysis and place the output in a new
\nsheet. Expand the column widths if necessary to reveal all the output without truncation.
\nYour output might resemble the truncated version of the output shown below:
\n15. Examine this data and consider its meaning (Important – 1).
\n16. Once the descriptive statistics are examined, go back to sheet \u201cPart A\u201d and repeat the
\nsteps to get to Excel Data Analysis ToolPak. Select the \u201ct-test: Two-Sample Assuming
\nEqual Variances\u201d.
\n17. Set the cursor in the Variable 1 box, and then highlight the column with Year 2000-2014
\ndata. The range should be \u201c$A$1:$A$148\u201d. Repeat with the Variable 2 box and the Year
\n2015-2021 data. The range should be \u201c$B$1:$B$65\u201d.
\n18. Click in the labels box to put a checkmark and take the default .05 significance level.
\n19. Enter 0 (the number zero) in the box for the hypothesized mean difference. Click on OK.
\n20. Excel will then complete the independent two-sample t-test and place the output in a new
\nsheet. Expand the column widths if necessary to reveal all the output without truncation.
\nYour output might resemble the truncated version of the output shown below:
\n21. Examine this data and consider its meaning (Important – 2).
\n22. Go back to the sheet \u201c2000-2014\u201d. Conduct the regression analysis with Adj Close as the
\ndependent variable (Y), and Date (X) as the independent variable. Assuming the level of
\nsignificance is 5%.
\n23. Repeat the steps to get to Excel Data Analysis ToolPak. Select the \u201cRegression\u201d.
\n24. Set the cursor in the Input Y Range box, and then highlight the column \u201cAdj Close\u201d. The
\nrange should be \u201c$F$1:$F$148\u201d. Repeat with the Input X Range box and the column
\n\u201cDate\u201d. The range should be \u201c$A$1:$A$148\u201d.
\n25. Click in the labels box to put a checkmark and take the default .05 significance level.
\nClick on OK.
\n26. Excel will then complete the regression analysis and place the output in a new sheet.
\nExpand the column widths if necessary to reveal all the output without truncation. Your
\noutput might resemble the truncated version of the output shown below:
\n27. Examine this data and consider its meaning (Important – 3).
\nReport
\nUse the given Template to upload a two to three pages report to Canvas by the Due Date. In your
\nreport, include the following:
\n\u2022 Your name at the top
\n\u2022 The following analysis output as described in this handout:
\nExhibit 1 (20 points): Screenshot of your \u201cDescriptive Statistics\u201d results.
\nExhibit 2 (20 points): Screenshot of your \u201ct-test: Two-Sample Assuming Equal Variances\u201d
\nresults.
\nExhibit 3 (20 points): Screenshot of your \u201cRegression\u201d results.
\n\u2022 Answers to the following questions:
\nQuestion 1 (20 points): Based on the \u201cDescriptive Statistics\u201d results, what\u2019s the mean value
\nfor Year 2000-2014 data, and what\u2019s the mean value for Year 2015-2021 data?
\nQuestion 2 (20 points): Based on the \u201ct-test: Two-Sample Assuming Equal Variances\u201d
\nresults, what\u2019s the mean value for Year 2000-2014 data, and what\u2019s the mean value for Year
\n2015-2021 data? Are they the same as the values in \u201cDescriptive Statistics\u201d results?
\nQuestion 3 (20 points): Based on the \u201ct-test: Two-Sample Assuming Equal Variances\u201d
\nresults, what\u2019s the p-value to compare the mean oil prices for Year 2000-2014 is More Than
\nthe mean oil prices for Year 2015-2021? Assuming the level of significance is 5%, what is
\nthe determination for this t-test?
\nQuestion 4 (20 points): Based on the \u201ct-test: Two-Sample Assuming Equal Variances\u201d
\nresults, what\u2019s the conclusion for t-test concerning if the mean oil prices for Year 2000-2014
\nis More Than the mean oil prices for Year 2015-2021? Assuming the level of significance is
\n5%.
\nQuestion 5 (20 points): Based on the \u201cRegression\u201d results, what\u2019s R-square of the model?
\nWhat does it mean? Explain briefly.
\nQuestion 6 (20 points): Based on the \u201cRegression\u201d results, what\u2019s the coefficient for the
\nvariable \u201cDate\u201d? How do you think about the relationship between the \u201cDate\u201d and \u201cAdjusted
\nClose price\u201d?
\nQuestion 7 (20 points): Based on the \u201cRegression\u201d results, what\u2019s the 95% Confidence
\nInterval for the \u201cDate\u201d?<\/p>\n","protected":false},"excerpt":{"rendered":"
BUSI 2342 Course Project Due Date: May 6th, 2022 11:59 PM Data Name: Crude Oil Future, 2000 \u2013 2021 Monthly NY Mercantile – NY Mercantile\u2026<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7316,7318,7317,7315,7319,7321],"tags":[642,618,8825,576,116,631,19,643,473,633,630,628,450,597,594,626,635,574,622,624,620,621,619,623,617,625,627,634,629,632,644,645,42,66],"class_list":["post-112830","post","type-post","status-publish","format-standard","hentry","category-best-dissertation-writers-uk","category-british-dissertation-writers","category-dissertation-help-online","category-dissertation-writing-services-uk","category-help-with-dissertation-writing","category-uk-dissertation-help","tag-apps-that-write-essays-for-you-free","tag-assignment-writing-services-in-usa","tag-bes","tag-best-dissertation-writing-services","tag-best-essay-writing-service","tag-best-paper-writing-services","tag-best-research-paper-writing-services-in-usa","tag-best-website-to-write-my-essay","tag-cheap-essay-writing-service","tag-cheap-research-paper-writing-service","tag-college-paper-writing-service","tag-dissertation-help-online","tag-dissertation-writing-services","tag-dissertation-writing-services-illegal","tag-dissertation-writing-services-near-me","tag-dissertation-writing-services-usa","tag-essay-writing-service","tag-free-dissertation-writing-services","tag-homework-essay-writer","tag-homework-essay-writer-free","tag-homework-help-global","tag-homework-help-services","tag-homework-help-usa","tag-homework-writing-help","tag-homework-writing-service","tag-legit-research-paper-writing-services","tag-legitimate-dissertation-writing-services","tag-research-paper-writer-online-free","tag-research-paper-writing-services-online","tag-research-paper-writing-websites","tag-write-my-essay-for-me-cheap","tag-write-my-essay-for-me-tik-tok","tag-write-my-essay-free","tag-write-my-paper"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/112830","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=112830"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/112830\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=112830"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=112830"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=112830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}