.Continue to use the data set of assignment2 Download assignment2from Canvas and save on your hard drive.Get into Excel and load the data set of
assignment 2
Use online chi-square calculator to perform a chi-square test to see whether there is a relationship between using the new software and job satisfaction.(
https://www.socscistatistics.com/tests/chisquare2/default2.aspx)
Use Analysis Toolpak to conduct a bivariate regression, using productivity as dependent variable and software as independent variable. Interpret the
intercept (constant term) and the coefficient of software.
Use Analysis Toolpak to conduct a multiple regression, using productivity as dependent variable. The independent variables include software, education,
experience, job satisfaction and age. Interpret the intercept and coefficients. What does the F-statistic tell you? What does the R-square tell you?Based on the
t-statistics, what can we say about the relationship between the independent variables and productivity in the population?
You will continue to evaluate the analysis memo in Assignment 2. Here is the context again
You ask your analyst to examine data on service delivery across substance abuse treatment providers in three cities: Chicago, IL; Washington, D.C.; and, Los
Angeles, CA. Each provider in this data set treats individuals with alcohol and/or drug use problems. In addition to basic information about the
characteristics of clients, the data file contains some basic information on the dimensions of services delivery or of services offered. The dataset also
includes a measure of program success—the percent of clients free of substance use for 6 months (both alcohol and drugs). This has been determined from
several random drug tests given the clients during the time. (Clients had to agree to the drug tests to participate in the program. Ignore the legal issues
surrounding this, and assume no attrition of clients.) You are now ready to look at the impact that the different dimensions of these programs have on the
clients remaining substance free. All of the persons in the dataset have experienced some type of treatment, so there is no comparison group, which
received no treatment. However, the clients have attended different providers, which provide a different array of services. Unfortunately, the data is only
available at the provider level, not individual client. You have collected some control variables to reflect the differences in the client population served by each
center.
Dimensions of Service Delivery
cityid
City identifier
hotline
Does facility operate or staff a hotline that provides substance abuse counseling and/or
referrals?
prevntn
Does the facility offer preventative services?
facility
Type of facility. Inpatient clinics involve overnight or long-term stays for more severe problems, outpatient clinics treat and release patients with less severe
problems.
waitlist
Does the facility maintain a waitlist that notifies clients when a service slot or opening exists?
waitnum
Number of people on the waitlist.
socserv
Does the facility help clients locate additional governmental social services (i.e., welfare, food stamps, Medicaid)?
healthed
Does the facility offer health education services (i.e., nutrition, infectious disease, STDs)?
parent
Does the facility offer parenting or family skills development?
Sample Solution