This assignment uses the data file Telco Extra CSUGlobal.xls (linked under Module 8: Portfolio Project on the modules page) (Solved)



This assignment uses the data file Telco Extra CSUGlobal.xls (linked under Module 8: Portfolio Project on the modules page) This data file concerns a telecommunications company's efforts to reduce churn in its customer base. Each case corresponds to a separate customer and records various demographic and service usage information. The data file contains the data on about half of the customers of the company, selected at random. In order to maintain the privacy of the customers, the identifying information (specific address, Social Security number) was stripped out.

The income data was purchased from an outside vendor. The telecommunications company would like to get a better understanding of customers who churn, as well as predict the income of a customer so that the company need not spend money purchasing the income data from an outside vendor.

Examine the 34 variables in the Telco data file in terms of their labels and values. Develop a research report to include the following components. Use SAS to produce the outputs and graphs.

  1. Introduction of the purpose of your paper. You should write this section after completing parts 2-6.
  2. Provide the sample characteristics in terms of age, years at current address, gender, level of education, income, marital status, region, custcat, and churn of the respondents in the sample based on the results of descriptive statistics you perform on the nine variables. Provide an appropriate graph for each of the variables using SAS.
  3. Choose churn to be the dependent variables and the other six variables mentioned in part (2). Omit the variable income for this part. Perform multiple linear regression analysis. This is to be done in SAS Studio.
  4. What would be the hypotheses in part (3)?
  5. Interpret the SAS output in terms of strength and direction of the relationship.
  6. Now, repeat parts (3)-(5) using income as the dependent variable. Omit the variable churn.

Summarize your results in both analyses. Also, state any surprises or unexpected findings. Do statistical results support your hypotheses, strength, and direction?

Copy and paste the SAS results and graphs in a Word document in addition to your answers. Ensure everything is clearly labeled. The report must be 10-12 pages long, including a title page and reference page (the report itself should be eight to ten pages). Cite two to three academic sources other than the textbook, course materials, or other information provided as part of the course materials. Follow APA format, according to CSU-Global Guide to Writing and APA (Links to an external site.).

Here are the Deliverables;

Use simplified clear language, American English syntax only

No British English spelling.

I already downloaded another paper from this site, please do not copy paste from that assignment

Aside from the Final paper, I need a separate instructions sheet with step by step guide to the functions so I can run the codes in my SAS program so I can get screen shots.

Related Questions in statistics category

The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.