Explore BrainMass
Share

Producing and Interpreting Descriptive Statistics

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

1.Calculate the mean, median, range, and standard deviation of home price and size. You can cut and paste the answers from the Analysis Toolpack, or you can place your results in the same Excel sheet as the data, below the existing table. Be sure to label each of your data calculations. (For example: Row 84 Column B should contain the Mean of Home Selling Prices, Column C the Mean of Home Size in Square Feet, Row 85 Column B should contain the Home Median price, and so on. Highlight all your results in yellow.)
2.Calculate the mode for the number of bathrooms. (You can cut and paste the answers from the Analysis Toolpack, or you can use Row 88 Column D for this parameter. Do not forget to title Column A Row 88-Mode. Highlight your results in yellow.)
3.Produce a histogram that shows the number of houses by price range, in increments of $50,000 (for example, $0-$50,000, $50,001-$100,000, and so on). Use a separate Excel sheet to do this and label that sheet "Home Price Range Histogram."
4.Produce a scatter plot showing the relationship between price and home size. In a cell under your scatterplot, indicate whether the relationship is positive or negative and whether the results are what you expect. Use a separate Excel sheet to do this and label the sheet "Scatterplot."

© BrainMass Inc. brainmass.com October 25, 2018, 9:40 am ad1c9bdddf
https://brainmass.com/business/business-and-industry-analysis/producing-and-interpreting-descriptive-statistics-582448

Attachments

Solution Preview

Calculate the mean, median, range, and standard deviation of home price and size by following the instructions below. Please see the attached Excel spreadsheet and the formulas entered into the cells. The spreadsheets have been named as follows:
Sheet 1 is the original spreadsheet, with calculations for the mean, median, mode, and range, as required in question #1 and 2.
Frequency is the original spreadsheet, with ...

Solution Summary

A calculation of the mean, median, range, and standard deviation of Florida pool home prices using Excel is shown. Excel is also used to find the mode, and create a histogram and scatterplot. The explanation includes over 250 words of text and an Excel file with 4 spreadsheets with all formulas and charts used.

$2.19
See Also This Related BrainMass Solution

Descriptive Statistics and Interpretation

I NEED ASSISTANCE SOLVING THE QUESTIONS BELOW BASED ON THE PAPER THAT HAS BEEN WRITTEN. PLEASE ATTACHED EXCEL AND WORD DOCUMENTS (THE PAPER DRAFT IS BELOW THE QUESTIONS)
Create a Microsoft® Excel® spreadsheet with the two variables from your learning team's dataset.
Analyze the data with Microsoft® Excel® or other statistical tool(s), including:
• Descriptive stats for each numeric variable
• Histogram for each numeric variable
• Bar chart for each attribute (non numeric) variable
• Scatter plot if the data contains two numeric variables
Determine the appropriate descriptive statistics.
• For normally distributed data use the mean and standard deviation.
• For significantly skewed data use the median and interquartile range.
Use the Individual Methodology Findings Template to complete the descriptive statistics.

Use the Descriptive Statistics and Interpretation Example to develop an interpretation of the descriptive statistics.
Format your paper consistent with APA guidelines.

Learning Team D Business Research
Corporations face different dilemmas every day that necessitate a decision making. These dilemmas could include costs changing, reduction in sales, employee turnover, etc. Normally identifying a business dilemma isn't the challenging part; it's the research that can be challenging. Determining the business issue directs management to make a proper research plan and answer the right questions to uncover the needed solution. Business research is a systematic inquiry that provides information to guide managerial decisions (Cooper & Schindler, 2011).
Background
COMPANY X is known as a well-reputed and customer-centric company but during the last five decades, the sales of the company at a macro level have been observed to be falling with a considerable pace. The reason some analysts have described is the shifting of the manufacturing plants from the home country to different foreign countries like China, Taiwan, and Vietnam. The reason behind the initiative of shifting manufacturing plants was to control the manufacturing costs and increase the profit margin overall, but the trick didn't work as per the predictions, and the overall scenario became dark.
Research Design
The research can be performed to assess the viability of the plan of shifting the manufacturing plants out there in different developing countries with a low cost of labor and increasing demand of foreign investment. The hypothesis that this research can weigh is about the cost reduction and change in profit margins of the company. The null hypothesis, thus, states as; whether the shifting of manufacturing plants has widened or narrowed the cost structure of the company against the alternative hypothesis that the current reduction in sales is not defined by the shifting of manufacturing plants in other countries.
The variables of interest chosen for this part of the study may be difficult to recognize. For the purpose, "profit margin" or the "overall revenue" of the company may be a good option for the dependent variable while the independent side will include the costs associated with shifting, hiring new labor and other such control variables to assess the whole scenario.
Hypothesis Statement
H0: There is no difference between the efforts of cost reduction through the shift of manufacturing plants and the change in the profit margin of the company.
H1: There is a difference between the efforts of cost reduction through the shift of manufacturing plants and the change in the profit margin of the company.
Research Question
"How effective was the initiative of shifting manufacturing plants in controlling the manufacturing costs in influencing the overall profit margin of the company?" This question will allow Learning Team D to:
• Determination of the focus and direction of the research project.
• The different types of hypothesis enable the team to state the purpose of the research study.
• Determination of the kind of variables to be taken into account for the accomplishment of the research.
Articles Summary and Relevant research
During the industrial revelation, the United States struggled from poor working conditions; this is an issue that the United States shared with so many other countries in the 20th Century, however, the third world countries continue to struggle today while these conditions disappeared in the United States due to following mandatory work regulations. Thus, we find large corporations tries to circumvent these regulations by moving big portions of their factories overseas and hire the cheap labor. This research studies the question "how effective was the initiative of shifting manufacturing plants on controlling manufacturing costs in influencing the overall profit margin of the company?" For this research different studies were made to analyze critically company X actions of shifting the manufacturing plants to offshore facilities. The articles' writers elucidated the reasons for this shift then attempt to clarify whether these reasons were justified.
In Company X case, shifting the majority of its production to overseas has more than one aspect; of course, the cheap labor aspects, production in the third world countries at a fraction of the production price domestically in the United States. Another aspect that is not often recognized in moving production especially to China, is the fact that China is the world most populous country, Company X was endeavoring to get the chance of clothing up to 2 billion people in china alone.
Clearly, the main driver of corporations to shift their production overseas is the labor's cost; however, costs in foreign countries are rising compared to the United States. This is a key factor for why 4 percent of corporations are relocating jobs back to the United States today. Despite the fact of the labor cost, X company might overlooked few other facts that could be considered big mistakes in moving Overseas such as; Productivity, in developing countries that measurably lower the United States labor cost tend to be higher in some cases to straight wage rate differences, moreover, evidence has it that the cultural differences carries barriers which introduce modern high productivity manufacturing process. Transportation, even with corporates discounts that most of shipping companies offer, shipping product remains very costly. Controlling risks like performing an on-site inspection can be rather difficult and costly overseas than at domestic locations. Also, Currency risk, Inventory risk, and political risks are facts that could be overlooked and affect manufacturing Overseas strongly to where effectiveness of the business can be easily vanished. According to the researches, the main reason for company X shifting overseas was to control the manufacturing costs, however, if company X hadn't shifted its manufacturing to overseas, the cost of products would have increased by 100$.
Company X has faced twenty years of criticism for outsourcing jobs overseas for the cheaper labor. The company's massive outsourcing has had a negative impact among labor unions and political critics who are worried about loss of American jobs. The international market has been able to offer American companies; such as, Company X the opportunity to source labor and products at better prices, which results in lower prices and more efficiency for businesses, which are then passed on as savings to their consumers.
Further issues ensue in regards to foreign labor laws. Each country has different laws, and, in addition, American companies are bound to human right protection laws. Some companies can mitigate labor laws by entering into agreements in which the foreign entity operates independently. Company X originally did this; however, investigation revealed human right violations so the company has now altered their arrangement with outsourced suppliers to include greater overseeing of factories and their processes.
It is difficult to be hands off and enjoy the benefits of cheaper labor while turning a blind eye to poor working conditions and inappropriate labor situations. Even worse is the backlash that ensues as a result of such inequities. Company X monitors the nearly 800,000 workers in their contract supply chain only to find that "many problems are recurring in the industry". (Nike, 2011). A potential solution to these issue are currently in the works between Company X and the white house is to ensure that human rights and safe manufacturing conditions are being observed based upon reasonable expectations and careful monitoring.
Conclusion
In business, management often meets uncertainty in their decision making. COMPANY X's plan to increase profits by shifting their manufacturing operations to foreign countries was unsuccessful due to a variety of reasons that directly affected production. Team D will focus on COMPANY X and conduct business research based on descriptive and comparative cost structures about the current and previous costs of the manufacturing plants.

Reference
Almaney, A. (2015). Strategic Analysis of Nike, Inc. Condor.depaul.edu. Retrieved 20 September 2015, from
http://condor.depaul.edu/aalmaney/StrategicAnalysisofNike.htm
Copper, D, & Schindler, P (2014) Business Research Methods (16th ed) McGraw-Hill Irwin Companies, Inc, NY
KUHNHENN, J., & WOZNIACKA, G. (2015, May 07). Obama's nike stop puts focus on outsourcing, labor standards. The Ledger Retrieved from
http://search.proquest.com/docview/1679378354?accountid=35812
Lohman, C., Fortuin, L., & Wouters, M. (2004). Designing a performance measurement system:
A case study. European Journal of Operational Research, 156(2), 267-286
Opsmgt.edublogs.org, (2012). Nike Operation in Vietnam | Operations Management & Business Issues in Today's Competitive Environment. Retrieved 11 September 2015, from
http://opsmgt.edublogs.org/2012/06/28/nike-operation-in-vietnam/
The Nike Controversy, By Matt Wilsey, Scott Lichtig
https://web.stanford.edu/class/e297c/trade_environment/wheeling/hnike.html
Tony Van Alphen, T. S. (1994, Mar 01). Nike plant shift will cost 100 jobs, union official says. Toronto Star Retrieved from
http://search.proquest.com/docview/436994942?accountid=35812
Van Dusen, S. (2010). The Manufacturing Practices of the Footwear Industry: Nike vs. the Competition. As accessed via the Internet at
http://www.unc.edu/~andrewsr/ints092/vandu.html.
We're Moving Overseas! Are We Making a Big Mistake? By Phillip Blackerby
http://www.blackerbyassoc.com/Overseas.html
Wilsey, M., & Lichtig, S. (2000). The Nike Controversy. Online im Internet [Stand: 3.01. 2001]
http://www. stanford. edu/class/e297c/trade_environment/wheelmg/hnike. html.
5 Facts About Overseas Outsourcing, By Alex Lach
https://www.americanprogress.org/issues/labor/news/2012/07/09/11898/5-facts-about-overseas-outsourcing/

View Full Posting Details