Excel Spreadsheet Grade Book Spreadsheet Term Paper

We can see that there exists a liner correlation, which means that attendance has a direct impact on final grade of students.

In order to built this function data from columns D3:D30 (attendance) and data from columns F3:F30 (final grade) from Spreadsheet 1 was tested using Linear regression formula of excel.

Results for m-coefficient of y=mx+b linear equation is in cell C70

Data for graph sketching is in table E70:E86:F70:F86

Interval for function argument is 0.01

Final grade is calculated by formula provided in cells F70:F86 y= 1.24*x-0.3

Spreadsheet 3

Attendance worksheet with 64 columns

Column a Student ID (chosen by student)

Column B. Student Name (hidden for privacy reasons)

Column C. Student Last Name (hidden for privacy reasons)

Column D. Attendance (calculated as total number of hours attended / total class hours), data was collected using data summing by selected criteria (cells D36:D41)

Columns D-BM Hours marked as attended "Y" or absent "N".....