OPRE 6301 - Statistics and Data Analysis Assignment

Reference no: EM132406337

OPRE 6301 - Statistics and Data Analysis Assignment - Problem Set, The University of Texas at Dallas, USA

Note: Please answer to each of the following questions by using the MS-Excel program. Prepare your answers in a MS-Word document or PDF and send both the Excel (showing your work) and Word files.

1. A number of social scientists claim that racial prejudice varies according to religious grouping. To explore this claim, a journalist asks a random sample of 793 adults to answer the following question: "Do you think that there should be laws against interracial marriage?" The journalist also asks questions that allow her to classify respondents by religious preference. Her tabulated data are as follows:

		Religious preference
		Fundamentalist	Moderate	Liberal	None
Law against interracial marriage	Favor	39	21	17	16
Law against interracial marriage	Oppose	142	248	236	74

Please analyze the data with respect to the scientists' claim about a connection between prejudice and religious grouping. Include your hypotheses, data analyses with the Excel and interpretation of the results.

2. Perform a cross-tabulation analysis along with a chi-square test using the raw data as follows:

(1) Use the "employee data.xls" data to create a contingency table using gender (1: male, 0: female) as an independent variable and job category (1: clerical, 2: custodial, 3: manager) as a dependent variable. The table should present both observed frequency and column percentage for each cell.

(2) Calculate expected frequencies for each cell.

(3) Use Excel to perform the chi-square test if job type allocations are different between male and female employees. Interpret the results.

3. Use the "marketvalues.xls" data to assess if and how much house size in squared feet ("sqft"), days on market before sold ("marktime") and purchase price in dollars ("value") are associated each other. Perform a correlation analysis in Excel and interpret the results.

4. Use the "marketvalues.xls" data to assess if purchase price (DV) is affected by house size (IV). Interpret all coefficients, test statistics and R-square.

Attachment:- Statistics and Data Analysis Assignment Files.rar

Reference no: EM132406337

Questions Cloud

What will be included in compensation and benefits package : As an HR Manager part of your job is to analyze the staffing levels within the organization. You have to hire to fill one position within the organization.

HSE 101 Introduction To Human Services Question : HSE 101 Introduction To Human Services assignment help and assessment help, Southern New Hampshire University - The definition of a human services agency.

Discuss how kathy lacked sufficient emotional intelligence : Discuss how Kathy lacked sufficient emotional intelligence to be effective in her new project manager assignment.

What is the cost of national prestige : Sochi Olympics-What is the Cost of National Prestige?

OPRE 6301 - Statistics and Data Analysis Assignment : OPRE 6301 - Statistics and Data Analysis Assignment - Problem Set, Homework Help, The University of Texas at Dallas, USA. Perform a cross-tabulation analysis

Identify the main argument or thesis of each article : Identify the main argument or thesis of each article and identify a minimum of three arguments or pieces of evidence used by the author to make their point.

OL620 Total Rewards Assignment Problem : OL620 Total Rewards assignment help and solutions, Southern New Hampshire University, assessment help - What is your opinion of Joan's view on job analysis.

Further substantiate his argument or compose rebuttal : Explain why the manager may have said it and then further substantiate his argument or compose a rebuttal.

How do you define a good appraisal format : How do you define a good appraisal format? What recommendations would you make to your current (or past) place of employment to improve their appraisals based.

User Account

All Pages