You will create a custom table in Excel for your chosen project based on the questions you created in the written assignment of this module. To get you started, here is a scenario to consider and here is the resulting Excel file with its custom table, based on the information that was researched in the scenario. Please review them to help you setup your own custom table for your project.
Create a custom table in Excel for your chosen project with charts that show:
• sampling techniques
• sample size
• mean
• deviations
Combine the charts on separate sheets with your written paper and add two additional pages explaining the table and the information shown on the table.
Scenario
Let's say that you chose Monster Beverage (stock abbreviation: MNST) as the company you was going to research. Your focus was to find out if there was going to be a total revenue difference (increase or decrease by year end) for Monster due to the fact that Coca Cola will be transferring ownership of NOS and Full Throttle Energy Drinks to Monster at the end of their first quarter, and Monster will be giving its non-energy portfolio to Coke and using their distribution network for their energy drinks.
By Module 4, you have already introduced the company, given the background of the merger decision, and explained what your research topic will be. The hypothesis you are using to begin your research will be that you want to prove that MNST's total revenue will increase due to the merger.
Your objectives will state that given the wide popularity of Coca Cola and the resources the company has brought to the table, MNST gross sales will increase from the fourth quarter 2014 of $2.8 billion to over $3 billion the end of 2015 due to increased sales arising from increased market exposure from Coke.
Your research will be designed to show historical sales of Monster Energy products and Coca Cola Energy products (NOS and Full Throttle) using nominal scales. The drawback to this research is using historical data to extrapolate future sales. For now, you don't need to survey anyone. You are using data that you can easily export into a spreadsheet.
For the week 4 Excel spreadsheet, you would show their financial data that can be found in each company's annual report. Copy this data into a spreadsheet and calculate standard deviation. Refer the sampling techniques and sample size in the report. See the sample Excel spreadsheet with two tabs - one for the data and one for the chart.
References
Coca Cola Form 10-K Annual Report Filed February 25, 2015. Retrieved April 27, 2015 from http://www.coca-colacompany.com/our-company/company-reports
Mcgrath, Maggie. Forbes Investing, August 14, 2014. Retrieved April 27, 2015 from http://www.forbes.com/sites/maggiemcgrath/2014/08/14/coca-cola-buys-stake-in-monster-beverage-for-2-billion/
Monster Beverage Corporation. Form 10-K
Annual Report Filed March 2, 2015. Retrieved April 27, 2015 from http://investors.monsterbevcorp.com/secfiling.cfm?filingID=1104659-15-15731&CIK=865752
Monster Beverage Corporation. Monster Beverage Reports 2014 Fourth Quarter and Full Year Financial Results. February 26, 2015. Retrieved April 27, 2015 from http://investors.monsterbevcorp.com/releasedetail.cfm?ReleaseID=898727
Directions for finding Standard Deviation in Excel
Find Standard Deviation in Excel 2013: Data Analysis
Step 1: Click the "Data" tab and then click "Data Analysis."
Step 2: Click "Descriptive Statistics" and then click "OK."
Step 3: Click the Input Range box and then type the location for your data. For example, if you typed your data into cells A1 to A10, type "A1:A10″ into that box
Step 4: Click the radio button for Rows or Columns, depending on how your data is laid out.
Step 5: Click the "Labels in first row" box if your data has column headers.
Step 6: Click the "Summary Statistics" check box.
Step 7: Select a location for your output. For example, click the "New Worksheet" radio button.
Step 8: Click "OK."
http://www.statisticshowto.com/find-standard-deviation-excel-2013/
Attachment:- Assignment.rar