library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.2.0     ✔ readr     2.1.6
## ✔ forcats   1.0.1     ✔ stringr   1.6.0
## ✔ ggplot2   4.0.2     ✔ tibble    3.3.1
## ✔ lubridate 1.9.4     ✔ tidyr     1.3.2
## ✔ purrr     1.2.1     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(readxl)
district<-read_excel("district.xls")

HOMEWORK

Students must formulate a plausible and testable hypothesis from the data they have selected. Deliverables will include a null hypothesis and an alternative hypothesis that can plausibly explain the data in question. Details on how to craft a testable hypothesis will be discussed in class. This assignment can be submitted via Rmarkdown or word document.

Define variables:

  1. Dependent variable (the outcome you are interested in) (x) The dependent variable is Drop Out Rate.

  2. Independent variable(s) (the variables which you think affect the outcome) (y) The independent variable is Attendance Rate.

Define your hypotheses:

  1. Null hypothesis - there is NO EFFECT of the Attendance Rate on Drop Out Rate.

  2. Alternative hypothesis - there is SOME EFFECT of Attendance Rate on Drop Out Rate.

Give me a few good paragraphs explaining your hypothesis and identifying your variables. I believe attendance affects drop out rates. The lower the attendance rate, the higher the drop out rate. Attendance has more of an affect on drop out rates, than other variables. I also think college prep course will have an effect on dropout rates.The higher college prep courses taken the lower the dropout rate. College prep courses will have a lower affect on dropout rates than attendance, but more than other factors.

I think attendance is an important variable because the more a student attends class, the less likely to dropout. The less class a student attends, the higher likelyhood to dropout of school because they get behind in their coursework and learning. However, students that are taking college prep courses, and miss classes are less likely to dropout. Students taking college prep courses tend to access tutoring and other types of student supports, and will tend not to dropout. Students who are not in college prep courses, typically do not have access to student supports and may also not have the financial means to receive tutoring or other student support, leading to dropping out of school.