Identify and evaluate valid statistical techniques

Assignment Help Basic Statistics
Reference no: EM132330257

Statistics and Research Methods for Business Decision Making Assignment -

Purpose of the assessment - 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.

Please read below information carefully and respond all questions listed.

Question 1 - Australian exports (goods and services) along with its top 8 export markets in 2004-05 and 2014-15 are shown in the table stored in file EXPORTS.XLSX (in the course website). Using this data, answer the questions below.

(a) Use an appropriate graphical technique to compare the value of Australian exports (in A$bn) in 2004-05 and 2014-15, broken down by country of export destination.

(b) Use an appropriate graphical technique to compare the percentage value of Australian exports (in %) in 2004-05 and 2014-15, broken down by country of export destination.

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

Question 2 - The following data are the 40 days umbrella sales from a store.

63

74

42

65

51

54

36

56

68

57

62

64

76

67

79

61

81

77

59

38

84

68

71

94

71

86

69

75

91

55

48

82

83

54

79

62

68

58

41

47

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 grades is less than 60?

f. What proportion of the grades is more than 70?

Use following class intervals to answer the above questions

Classes

Frequency

Relative Frequency

Cumulative Frequency

Cumulative Relative Frequency

30 - 40

 

 

 

 

40 - 50

 

 

 

 

50 - 60

 

 

 

 

60 - 70

 

 

 

 

70 - 80

 

 

 

 

80 - 90

 

 

 

 

90 - 100

 

 

 

 

Question 3 - Assume you are a research analyst in an economic consultancy firm. Your team leader has given you a research task to investigate whether the per capita retail turnover in Australia is a good predictor of the final consumption expenditure of the country.

Relevant Variables: FINAL CONSUMPTION EXPENDITURE: (Trend) in $ Millions; - quarterly data from September 1983 to March 2016.

RETAIL TURNOVER PER CAPITA - (Trend) Total (State) in $;- quarterly data from September 1983 to March 2016.

[Quarterly time series data (for the period September 1983 to March 2016) are from the Australian Bureau of Statistics (ABS)]

The data are stored in the file named "ASSIGNMENTDATA.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 FINAL CONSUMPTION EXPENDITURE and RETAIL TURNOVER PER CAPITA. 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 FINAL CONSUMPTION EXPENDITURE and RETAIL TURNOVER PER CAPITA. 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 whether FINAL CONSUMPTION EXPENDITURE positively and significantly increases with RETAIL TURNOVER PER CAPITA 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?

Attachment:- Assignment Files.rar

Verified Expert

This assignment is about graphical analysis of the two ex ports data and interpreting the results from the graph, construction of frequency distribution and analysis of data using correlation and regression model.

Reference no: EM132330257

Questions Cloud

Explanation of the role of mentorship : Many factors are considered when termination of parole is determined. Provide an introduction to the issue, including an explanation of the role of mentorship
A program that computes the sum of the squares of numbers : A program that computes the sum of the squares of numbers read from a file. Also include a main method where you ask the user to input the name of the file.
Define different functions for the conversions : Define different functions for the conversions. Call these functions within the while loop. Use docstrings for your comments.
Prepare legal advice on the WTO-consistency : Exercise 6: Carlie goes to Europe (page 962): Prepare legal advice on the WTO-consistency of the various measures referred in the case
Identify and evaluate valid statistical techniques : Statistics and Research Methods for Business Decision Making - how understanding of the principles and techniques of business research and statistical analysis
How to protect home and office from cyberattack : Do some research, analyse the information and give your recommendations (at least 3) how to protect home and office from cyberattack
Build routing table for edge routers to connect states : Understanding of the Internet Protocol, which is the major underlying technology of the Internet and importance of subnet and routing of IP address
Ask the user for a length and a width of a rectangle : Asks the user for a length and a width of a rectangle. Each or all input will happen in a function and will then be returned from a function.
Demonstrate the use of nested function calls : Add a function named clear_screen that uses a combination of the functions nine_lines, three_lines, and new_line.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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