User Account

All Pages

Prepare a business report on statistics and data analysis

Assignment Help Supply Chain Management
Reference no: EM131276073

Assignment
Statistics and Data Analysis
Businesses often survey their customers and employees to find out what they want and what they are doing. In the era of big data where everything is connected to the Internet and every devicecollects data, meaningful data analysis has become ever more important. Excel is a great tool to help managers decipher data and make sense out of it. Please read the following few articles to understand what surveys are and what Excel can do to help you analyze data.

https://www.surveymonkey.com/mp/business-surveys/ (from one of the most popular FREE online survey site)

https://www.willamette.edu/~dnegri/courses/econ230/Data_Analysis_Toolpack_Guide.pdf (brief introduction of Excel's Data Analysis functions)


In Excel, one would need to install the optional Data Analysis Tookpak to use these statistical tools. Once installed, one may choose Data, Data Analysis, then select the analysis you want done. It's that simple!


Assignment: Please recreate the spreadsheet per the PDF file using the shell provided. Be sure to use formulas in cells with blue figures. Use the data analysis tool to create the t-test and histogram results and the histogram chart. Modify the chart so that it looks pretty. Do the same for all survey questions then answer the following questions:

1. For question 2, are there significant differences between group 1 and group 0? How confident can we say that the two groups have different opinions about question 2?
2. How about questions 3, 4, and 5?


Attachment:- scm_350_assignment_5_.xlsx

Reference no: EM131276073

Questions Cloud

What is the conservation of value principle : What is the conservation of value principle? Provide some examples of where it might apply.- Under what circumstances would changing a company's capital structure affect its value?
Develop equations for the logical effort and parasitic delay : Consider all of the internal diffusion capacitances when deriving the parasitic delay. Use the transistor widths shown in Figure 11.98 and assume the Pi and Gi transistors of each stage share a single diffusion contact.
Production cost per unit and selling price per unit : Stickley Furniture Company is a manufacturer of fine hand- crafted furniture. During the next production cycle, management is considering producing dining room tables, dining room chairs, and bookcases. The requirements for each item are shown below,..
How much cash flow risk should a company take on : How do diversifiable and nondiversifiable risks affect a company's cost of capital?- On what basis should a company's managers decide which risks to hold and which to hedge?
Prepare a business report on statistics and data analysis : Prepare a business report on Statistics and Data Analysis and give the answer below Question.
Find net present value and internal rate of return : Calculate the cash flows of the project given the following assumptions: Compute net present value and internal rate of return of the project. You may use Excel to complete this project.
Develop a boolean equation for overflow : Repeat Exercise 11.2 for a signed add/subtract unit like that shown in Figure 11.41(b). Your overflow output should be a function of the subsignal and the most significant bits of the two inputs and the output.
What are total returns to shareholders : What are total returns to shareholders (TRS), and why is this measure important?-  What is the expectations treadmill, and how does it affect managers' ability to deliver above-average TRS over long periods of time?
What is the value of the companys inventory at year end : What is the value of the company's inventory at year end? What was the amount of cost of goods sold for the year? What income statement format does the company use? Explain.

Reviews

Write a Review

Supply Chain Management Questions & Answers

  Understanding of project procurement management

Project Managers need to have an understanding of Project Procurement Management because the ________.

  Environmental factors that indirectly affect organisation

Macro External Environment: Environmental factors that indirectly affect the organisation, such as government legislation, demographic and social trends. Comprises political, economic, socio-­-cultural, technological, environmental & legal environmen..

  Formulate the linear programming problem to minimize cost

Formulate this as a linear programming problem to minimize cost. How many units of each type should be produced each month? What is the total cost of thissolution?

  Case study- supply-chain challenges in post-earthquake japan

Case Study: Supply-Chain Challenges in Post-Earthquake Japan. Explain the advantages and disadvantages of the supply chain used in the Japanese auto industry before the earthquake and tsunami.

  Significant role in organisational effectiveness

Strategic Human Resource Management (SHRM) plays a significant role in organisational effectiveness (Gallup Consulting, 2010; Pfeffer & Veiga, 1999).

  Does the public client require to move for ptn

Debate to support the public procurement legislation that prohibits post-tender price negotiation for the NHS should not be relaxed.

  What percentage of time is judy idle

What is the probability that an arriving student (just before entering the Administrative Services Office) will find at least one other student waiting in line?

  How will setting supply chain standards improve scm

Please supplement the paper with other references of your choice. How will setting supply chain standards improve supply chain management?

  Why death seems so common in advertisements

What are some of the political, social, sexual or psychological reasons why death seems so common in advertisements? Why are more women represented in situations of death than men? What negative effect could these type of ads have on women, men, and ..

  Problems at with the current logistics network in nsw

Company and relevant case studies on related companies the case, prepare a 2000 - 2500 word report analysing the issues in the case, and identify logistics management strategies to resolve the issues

  What is meant by the channel of distribution

Most organizations seek consumer information, yet, why is a competitor analysis a crucial approach to evaluate the marketplace? List and explain the data to include in this analysis. List and explain five important changes/trends affecting marketing ..

  Explain how standardizing designs decreases logistics costs

An article describing Volkswagen's success suggests that standardizing around 60 % of the components in the platforms for medium sized and small sized cars globally decreased costs by 20 %. Explain how standardizing designs decreases logistics cos..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd