The purpose of the project is for you to gain experience in applying statistical method of multiple regression.




The purpose of the project is for you to gain experience in applying statistical method of multiple regression.



Questions and online hours: Q&A with Instructor and email communications.


Project Description


The general description of this project stems from research associated with self-efficacy and its relationship with academic performance and persistent. 


The standard project is to use multiple regression analysis to analyze a data set.  The data set is a study of student persistent enrolling in the next semester based on Gender, Age, GPA, a 22 questionnaire on self-efficacy, and student enrollment status. 


The educational researcher wants to study the relationship between student enrollment status as it relates to gender, age, GPA, and the total response to a 22 questionnaire survey.


Data Sets


The data consist of 130 students at a 2-year college.  The data has been converted to Excel.


For the qualitative variables use the following to prepare data.


Gender – 0 represents female, 1 represents male

Age – 0 represents student age (18 – 25), 1 represents student age (26 – older)

GPA – student’s current grade point average

Total Q – total of the 22 questions (all question responses come from a scale of 1 – 5, where 5 high.

Enrollment status – 0 represents not enrolled, 1 represents enrolled.


Items to turn in


  1. BigDataProjectTemplate Excel Sheet with the following:
    1. The data setup for the multiple regression should include in the tab name Data Setup for Regression
    2. include a residual output, may require research ( See video examples of how to use Multiple Linear Regression using Microsoft Excel)


  1. The following questions are included in the BigDataProjectTemplate sheet in the tab name Questions and Answers.
    1. The estimated multiple regression analysis equation.
    2. Does the model work? Research this question, use the Significance F value and compare it using p-value.
    3. How well does the model work? Research this question using p-values and R Square.
    4. Which variables contribute to the model? Research this question using p-values.


  1. Upload BigDataProjectTemplate as file BigDataProject your name
  2. Each group member should upload as individual upload.

Related Questions in statistics category