Prepare a numerical summary report about the data

Assignment Help Other Subject
Reference no: EM132366159

Purpose of the assessment (with ULO Mapping)

Students are required to show the understanding of the principles and techniques of business research and statistical analysis taught in the course.

Assignment Specifications

Purpose:

This assignment aims at Understand various qualitative and quantitative research methodologies and techniques, and other general purposes are:

1. Explain how statistical techniques can solve business problems
2. Identify and evaluate valid statistical techniques in a given scenario to solve business problems
3. Explain and justify the results of a statistical analysis in the context of critical reasoning for a business problem solving
4. Apply statistical knowledge to summarize data graphically and statistically, either manually or via a computer package
5. Justify and interpret statistical/analytical scenarios that best fits business solution

Question 1

The planet may be threatened by climate change due to unsustainable activities, possibly caused by burning fossil fuels (petroleum, natural gas and coal) that produce carbon dioxide (CO2). The table stored in file CO2 EMISSIONS.XLSX (in the course website) lists the top 15 producers of CO2 (millions of metric tonnes) from fossil fuels in 2009 and 2013. Using this data, answer the questions below.

(a) Use an appropriate graphical technique to compare the amount of CO2 emissions (in millions of metric tonnes) in 2009 and 2013, broken down by the producer countries.

(b) Use an appropriate graphical technique to compare the percentage value of the amount of CO2 emissions (in %) in 2009 and 2013, broken down by the producer countries.

(c) Comment your observations in parts (a) and (b).

Question 2.

The amount of time (in seconds) needed for assembly-line workers to complete a weld at a car assembly plant in Adelaide was recorded for 40 workers.

 

59

60

81

74

68

66

49

76

63

67

69

35

65

61

43

72

83

65

69

70

54

61

38

92

72

74

55

63

69

73

75

47

60

62

68

51

71

73

68

99

a. Construct a frequency distribution and a relative frequency distribution for the data.
b. Construct a cumulative frequency distribution and a cumulative relative frequency distribution for the data.
c. Plot a relative frequency histogram for the data.
d. Construct an ogive for the data.
e. What proportion of the data is less than 65?
f. What proportion of the data is more than 75? Use following class intervals to answer the above questions

 

Classes

Frequency

Relative Frequency

Cumulative Frequency

Cumulative

Relative Frequency

35 - 45

 

 

 

 

45 - 55

 

 

 

 

55 - 65

 

 

 

 

65 - 75

 

 

 

 

75 - 85

 

 

 

 

85 - 95

 

 

 

 

95 - 105

 

 

 

 

Question 3.

Because inflation reduces the purchasing power of the dollar, investors seek investments that will provide protection against inflation; that is, investments that will provide higher returns when inflation is higher. It is frequently stated that ordinary shares provide just such a hedge against inflation. The annual Australian inflation rate (as measured by percentage changes in the consumer price index) and the annual All-Ordinaries Index from 1995 to 2015 are stored in file INFLATION.XLSX (in the course website).

Using EXCEL, answer below questions:

a. Using an appropriate graphical descriptive measure (relevant for time series data) describe the two variables.

b. Use an appropriate plot to investigate the relationship between RATE OF INFLATION and ALL- ORDINARIES INDEX. Briefly explain the selection of each variable on the X and Y axes and why?

c. Prepare a numerical summary report about the data on the two variables by including the summary measures, mean, median, range, variance, standard deviation, and coefficient of variation, smallest and largest values, and the three quartiles, for each variable.

d. Calculate the coefficient of correlation (r) between RATE OF INFLATION and ALL-ORDINARIES INDEX. Then, interpret it.

e. Estimate a simple linear regression model and present the estimated linear equation. Then, interpret the coefficient estimates of the linear model.

f. Determine the coefficient of determination R2 and interpret it.

g. Test the significance of the relationship at the 5% significance level.

h. What is the value of the standard error of the estimate (se). Then, comment on the fitness of the linear regression model?

Reference no: EM132366159

Questions Cloud

Impact strategic decision-making from a leadership : Need an educated opinion on the impact strategic decision-making from a leadership perspective has on the lives of individuals
Discuss the strategic imperative of learning organization : 1. Discuss the strategic imperative of learning organization and the need to attract and retain skillful human capital.
Describe the role of data mining : Describe the role of a data mining in that article in your own words.
Identify and discuss attributes of strategic management : 1. Identify and discuss attributes of Strategic Management and its application to the success of business organization.
Prepare a numerical summary report about the data : Prepare a numerical summary report about the data on the two variables by including the summary measures, mean, median, range, variance, standard deviation
Explain how shared beliefs have affected a specific issue : Define a specific topic or issue to be addressed and explain its importance in the field of higher education. Explain how shared beliefs have affected.
What credibility issues can arise from information : What credibility issues can arise from information you present on the Internet? Please explain with a creditable resource and citations.
How institutional practices have helped to advance access : While acts of Congress and U.S. Supreme Court rulings have opened the doors of higher education to women and minorities, debate continues about equitable.
How institutions responded to economic and legal pressures : Financing college and university operations has always been a challenge. Thelin (2019) notes that "one of the most perplexing historical riddles in American.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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!

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