Question

bickley academy is a competitive private college - preparatory high school. bickleys administration is now considering applications from the three local junior high schools: montgomery, cleeghen, and benson. bickleys admissions department has compiled a file named bickley that contains the first name, last name, email address, and grade - point average (gpa) for applicants from these schools.
click on the datafile logos to reference the data
data file
bickleys director of admissions, joan bisdubic, would like to look at the relationship between these students gpas and the schools they are attending. the school each student is attending can be identified by the domain name in the students email address. to ensure each applicant receives full and proper consideration, joan bisdubic would also like to ensure that the file has the gpa for every applicant.
create a new set of data from the data in the file bickley that includes the applicants first name, last name, email username (the portion of the email address that precedes the @ symbol), email domain (the portion of the email address that follows the @ symbol), and gpa. save your file under the name bickleyapp.xlsx. what is the mean gpa of the applicants from cleeghen? round your answer to three decimal places

Explanation:

Step1: Filter data

Filter the data in the bickley file to only include applicants from Cleghorn.

Step2: Calculate sum of GPAs

Sum up the GPAs of all the filtered applicants. Let the sum be $S$.

Step3: Count number of applicants

Count the number of applicants from Cleghorn. Let the count be $n$.

Step4: Calculate mean

The mean GPA $\bar{x}=\frac{S}{n}$.

Answer:

(The actual numerical value cannot be determined without the actual data in the bickley file. But the formula to calculate it is $\bar{x}=\frac{S}{n}$ where $S$ is the sum of GPAs of Cleghorn - applicants and $n$ is the number of Cleghorn - applicants.)