Business Statistics Computer Assignment

Computer Assignment Problem - Answer all FIVE Questions

Some critics raised complaints that the amount of violence shown on television contributes to violence in our society. Others pointed out that the high level of obesity among children may be attributed to their exposure to television. Now, we may have to add financial problems to the list. A sociologist theorised that people who watch television frequently are exposed to many commercials, which in turn lead them to buy, resulting in increasing debt. To test this belief, a researcher plans to survey a sample of families across the country.

QUESTION 1 - Briefly explain (using no more than 300 words in total for this Question)

(a) What type of survey method the researcher could use and why?

(b) What sampling method could the researcher use to select his/her sample and why?

(c) What are the variables the researcher should consider collecting data for the purpose of the analysis and why? Identify the data type(s) for the variables.

(d) What kind of issues the researcher may face in this data collection?

Suppose the researcher collected data from 395 randomly selected families. For each family, the number of hours the television is turned-on per week and the total debt were recorded.  The data are stored in file DATA FILE.XLS which is available in the "Assessment" - "Computing Assignment" section of the 1304AFE unit website. Using this data and EXCEL, answer questions 2, 3 and 4 below.

QUESTION 2 - First, the researcher wishes to use the graphical descriptive methods to present the data.

(a) He suggests using class intervals such as 0-6, 6-12, 12-18, ... for one variable and class intervals 0-30000, 30000-60000, 60000-90000, .... , for the other variable.  Explain how he would decide on the number of classes and the above class intervals.

(b) Use appropriate BIN values to draw a histogram for each variable and comment on the shape of the two distributions.

(c) Use an appropriate plot to investigate the relationship between the two variables.  Briefly explain the selection of each variable on the X and Y axes and why?  On the same plot, fit a linear trend line including the equation and the coefficient of determination.

QUESTION 3 - Second, the researcher wishes to use the numerical descriptive measures to summarize the data.

(a) Prepare a numerical summary report about the data on the two variables the researcher has considered by including the summary measures, mean, median, range, variance, standard deviation, smallest and largest values and the three quartiles, for each variable.

(b) Compute a numerical summary measure to identify the direction and to measure the strength of the relationship between the two variables. Interpret this value. 

QUESTION 4 - The researcher considers using regression analysis to establish a linear relationship between the two variables.

(a) What is his dependent variable and independent variable? Why?

(b) Estimate a simple linear regression model and present the estimated linear equation. Interpret the intercept and slope coefficient estimates of the linear equation.

(c) Interpret the coefficient of determination, R-squared (R2) value.

QUESTION 5 - (Show all working in EXCEL by setting up a table)

A shopping mall estimates the probability distribution of the number of stores mall customers actually enter (X), as shown below:

(a) Calculate the value of k.

(b) Calculate the mean of number of stores entered.

(c) Calculate the standard deviation of the number of stores entered.

Attachment:- DATA FILE.rar