Calculate the mean of number of stores entered

Assignment Help Applied Statistics

Reference no: EM131359267

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.

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:

X	0	1	2	3	4	5	6
p(x)	0.03	0.25	0.14	0.30	2k	0.10	k

(a) Calculate the value of k.

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

Attachment:- DATA FILE.rar

Reference no: EM131359267

Questions Cloud

What are the various inputs transformations and outputs : What are the various inputs, transformations and outputs? Are there subsystems? What processes of feedback and adaptation do you see?

What will be the eoq : (I) What will be the EOQ? (II) Find the purchase cycle time? (III) Find the total inventory cost per year?

Find the additional rotor resistance : The rotor resistance and reactance of a wound-rotor induction motor at standstill are 0.14 ohm per phase and 0.8 ohm per phase, respectively.

Evaluate the effectiveness of the program : You helped implement the toll collection system and returned three years later to evaluate the effectiveness of the program. Data on toll collections and traffic volumes are available on a day-to-day basis.

Calculate the mean of number of stores entered : 1304AFE Business Statistics Computer Assignment. A shopping mall estimates the probability distribution of the number of stores mall customers actually enter (X), as shown below: Calculate the mean of number of stores entered

Describe how you would like to involve the department : Gain the trust of the department heads by offering a clear explanation of the need for change.Briefly outline the steps you may use to facilitate this change process.Describe how you would like to involve the department heads with this process.

Calculate the following rotor starting current per phase : The rotor resistance and reactance of a squirrel-cage induction motor rotor at standstill are 0.14 ohm per phase and 0.8 ohm per phase respectively.

Economic batch quantity of a product on a machine : Find the most economic batch quantity of a product on a machine if the production rate of that item on the machine is 200 pieces per day and the demand is uniform at the rate of 100 pieces per day. The ordering cost is Rs. 200 per batch and the co..

How frequently should production run be made : The cost of holding a bearing in stock for one year is Rs.2 and the set-up cost of a production run is Rs.1,800. How frequently should production run be made?

Reviews

len1359267

1/19/2017 12:23:52 AM

All numerical calculations and graphs/plots should be done using EXCEL. Your assignment must be typed in a Word document in .doc or .docx format – no pdfs! When answering questions, wherever required, you should cut and paste the Excel output (eg, plots, regression output etc) to show your working/output on your assignment. You are required to keep a hard copy and an electronic copy of your submitted assignment to re-submit, in case the original submission is lost for some reason. Please fill your student name and student ID, as well as other requested info on the assignment coversheet. Then attach the cover sheet on the first page of your assignment answers. As this is an individual assessment item, students should work on their own and present their individual assignment submission, even if you discuss it in a group. If found to have cheated, all submissions involved would receive a mark of zero for this assessment item.

Write a Review

Required(*) Message

User Account

All Pages