Internal Code: 1ABBDA

Business Analytics and Statistics Project Writing Assignment Help

Task: 1

A sociologist theorized that people who watch television frequently are exposed to many commercials, which in turn lead them to buy these goods, resulting in increasing debt. To test this belief, a researcher plans to survey a sample of families across the country. 

Briefly explain

(a) What type of survey method could the researcher 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?

(d) Identify the data type(s) for the variables mentioned in part (c).

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

Suppose the researcher collected data from 400 randomly selected families. For each family, the Total debt (in $) and the number of hours the television is turned-on per week (TV hours) were recorded.  

The data is stored in the file TVDEBT.XLS.

Using this data set and EXCEL, answer the questions below.

Task: 2

First, the researcher wishes to use the graphical descriptive methods and numerical descriptive measures to present the data for the two variables.  

(a) The researcher decides to use 10 class intervals such as 0<X?6, 6<X?12, 12<X?18, ….., 54<X?60  for the TV hours variable and class intervals 0<X?30000, 30000<X?600000, 60000<X?90000, …. , 270000<X?300000 for the Total debt variable. Explain how the researcher would have decided on 10 class intervals.

(b) Draw a histogram for each variable using appropriate BIN values from part (a).

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

Notes:  Use QUARTILE.EXC command to generate the three quartiles

(d) Based on your histograms in part (b) and descriptive summary measures in part (c), comment on the skewness of the distribution of the two variables.

Task: 3

Second, the researcher wishes to investigate the association between the two variables.

(a) Explain what could be the independent variable (X) and the dependent variable (Y).

(b) Using Excel, compute the numerical measure that provides information about the direction and strength of the linear relationship between the Total debt and TV hours. Interpret this value.

(c) Using an appropriate plot, investigate the relationship between Total debt and TV hours.  On the same plot, fit a linear trend line.

(d) Display the regression summary table. Using the summary results, estimate the Least Squares Regression equation and interpret the intercept and slope coefficient estimates of the estimated linear regression model.

(e) Interpret the value of the coefficient of determination, R-squared (

R

2

).

(f) Using the regression summary output table, conduct a hypothesis testing to conclude whether there is a linear relationship between weekly take-home pay and weekly food expenditure. Use

?=0.05

.

Task: 4

(a) Based on your answers above, write a summary report about the findings of the study conducted by this researcher 

This STA510: Business Analytics and Statistics Assignment has been solved by our Business Analytics and Statistics experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Kadiriye
  • Posted on : January 17th, 2017
Hire A Tutor
loader

Whatsapp Tap to ChatGet instant assistance