There are two sections (see QUESTIONS FOR THE PROJECT):Data Exploration and Preliminary AnalysisMultiple Regression/Model BuildingYou will perform some analyses in Excel, save it and then provide a summary in Word. There is no required length. You are going to be graded on completing the EXCEL portion and the summarizing of the data in WORD/PDF document. I will not grade on grammar. You are encouraged to use the class notes for the exercise. COMMON EXCEL FORMULA=AVERAGE() =MEDIAN() =STDEV.S() - Std Dev for a sample=STDEV.P() - Std Dev for a population =VAR.S() - variance for a sample=VAR.P() - variance for a population QUESTIONS FOR THE PROJECTPART 1: Data Exploration and Preliminary AnalysisDUE DATEQUESTIONS, PART IPoint Value1How many data points are there in each data set?12What is the average, median, variance and standard deviation of each variable?73Graph each variable using a bar chart54Are the data skewed?1Which direction?1Why? (Use a Z-score to prove your reasoning)55Summarize the nation and the dependent variables that are possible outliers.5TOTAL25PART 2: Multiple RegressionDUE DATEQUESTIONS, PART IIPoint Value6Create scatter plots between the dependent and each independent variable? Show the individual R2 value. What are the correlations? Which variable seems to be the strongest and weakest?107Determine the formula for this regression.18What is the coefficient of determination? What is the adjusted coefficient of determination? What does each mean?39At what point is each independent variable significant? What does a 1 unit increase in each independent variable do to the dependent variable?410What is the mean squared error for this model? What does it mean?311Test the overall significance of the model.4TOTAL25UPLOAD YOUR RAW DATA FILE AND A SUMMARY IN WORD/PDF FORMAT

Assignment: Kaplan-Meier CurveThe Kaplan-Meier curve is a way to evaluate longitudinal data and estimate conditional survival rates through the illustration of a series of conditional probabilities.For this Assignment, you use the Kaplan-Meier method to evaluate time-to-event data collected through a longitudinal study described in the Week 8 Dataset (SPSS document). You also create a survival curve and estimate survival distributions.The AssignmentUsing Week 8 Dataset (SPSS document) from the Learning Resources area, answer the following:Data (20 Points)Create a variable for Time-to-event by subtracting the start time (variable = start) from the stop time (variable = stop). Label the new variable “Time”. (10 Points)Produce the appropriate descriptive statistics, numerical and graphical, for the following variables: (10 Points)EventIntervalTxNumSizeTimeKaplan-Meier Survival Analysis (Without factor or Strata) (30 Points)Run a Kaplan-Meier analysis in SPSS, using Time as the Time variable and Event as the Status variable (Be sure to define the event). Do not add a factor or strata at this time.Produce a Survival Table (you do not need to submit this) (10 Points)Produce a plot of the survival function (10 Points)What is the mean survival time (include confidence intervals)? What is the median survival time (include confidence intervals)? Why do you think they are so different from each other? (10 Points)Kaplan-Meier Survival Analysis (With Factor) (30 Points)Run a Kaplan-Meier analysis in SPSS, using Time as the Time variable and Event as the Status variable (Be sure to define the event). Add Tx as the factor.Test the difference between Tx groups (Compare Factor) using Log-Rank, Breslow, and Tarone-Ware (10 Points)Produce a plot of the survival function (10 Points)Describe what the Overall Comparisons mean in terms of treatment groups and survival times. (10 Points)Kaplan-Meier Survival Analysis (With Strata) (20 Points)Run a Kaplan-Meier analysis in SPSS, using Time as the Time variable and Event as the Status variable (Be sure to define the event). Add Interval as the Strata variable.Produce a plot of the survival function for each strata. (10 Points)Why would you want to produce Kaplan-Meier Survival Curves after stratifying for a variable? (10 Points)

(1) At a baseball game, five men; L, M, N, 0 and P, and five women, S, T, U, V and W, occupy a row of ten seats. The men are in odd-numbered seats, starting from the left; each woman sits to the right of the man she is dating. (2) 0 is V‟s date (3) W is not at the right end of the row and the man the is dating is not at the left end of the row. (4) The man dating W likes T best among the other women and insists on being seated to the right of T. (5) N is one seat from the right end of the row. (6) M and his date occupy the middle pair of seats (7) V sits next to M. Question 1:- Which of the following lists five persons who must sit adjacent to one another, from left to right (A) U, V, O, M, T (B) M, T, L, W, L (C) O, V, M, T, W (D) O, V, M, T and either L or P Question 2:- U‟s date may be: (A) N or L (B) L or P (C) N or P (D) N, L or P Question 3:- Which of the following cannot be determined on the basis of the information given? I. Who occupies the seat farthest to the left. II. Who occupies the seat farthest to the right. III. Which other women are nearest to T (A) I only (B) III only (C) I and II only (D) II and III only Question 4:- Which of the following could be determined exactly if the position of either L or P were given? (A) The identity of L‟s date (B) The identity of P‟s date (C) The identity of L‟s date or P‟s date, but not both (D) Which woman is no seated between two menQuestion 5:-. In order to determine the position of T, it is necessary to use how many of the numbered statements? (A) 3 (B) 4 (C) 5 (D) 6