Reference no: EM131261167
Focusing on Data Analysis - UWEC Undergraduates
The file named Focus.txt in the Focus Database section of the WeissStats site contains information on the undergraduate students at the University of Wisconsin - Eau Claire (UWEC). Those students constitute the population of interest in the Focusing on Data Analysis sections that appear at the end of each chapter of the book.
Thirteen variables are considered. Table 1.9 lists the variables and the names used for those variables in the data files. We call the database of information for those variables the Focus database.
Also provided in the Focus Database section is a file called FocusSample.txt that contains data on the same 13 variables for a simple random sample of 200 of the undergraduate students at UWEC. Those 200 students constitute a sample that can be used for making statistical inferences in the Focusing on Data Analysis sections. We call this sample data the Focus sample.
Large data sets are almost always analyzed by computer, and that is how you should handle both the Focus database and the Focus sample. We have supplied the Focus database and Focus sample in several file formats in the Focus Database section of the WeissStats site.
If you use a statistical software package for which we have not supplied a Focus database file, you should (1) input the file Focus.txt into that software, (2) ensure that the variables are named as indicated in Table 1.9, and (3) save the worksheet to a file named Focus in the format suitable to your software, that is with the appropriate file extension. Then, any time that you want to analyze the Focus database, you can simply retrieve your Focus worksheet. These same remarks apply to the Focus sample as well as to the Focus database.
TABLE - 1.9 Variables and variable names for the Focus database
Variable
|
Variable name
|
Sex
|
SEX
|
High school percentile
|
HSP
|
Cumulative GPA
|
GPA
|
Age
|
AGE
|
Total earned credits
|
CREDITS
|
Classification
|
CLASS
|
School/college
|
COLLEGE
|
Primary major
|
MAJOR
|
Residency
|
RESISDENCY
|
Admission type
|
TYPE
|
ACT English score
|
ENGLISH
|
ACT math score
|
MATH
|
ACT composite score
|
COMP
|
Recall from Chapter that the Focus database and Focus sample contain information on the undergraduate students at the University of Wisconsin - Eau Claire (UWEC). Now would be a good time for you to review the discussion about these data sets.
Open the Focus sample worksheet in the technology of your choice and do the following.
a. Find the linear correlation coefficient between cumulative GPA and high school percentile for the 200 UWEC undergraduate students in the Focus sample.
b. Repeat part (a) for cumulative GPA and each of ACT English score, ACT math score, and ACT composite score.
c. Among the variables high school percentile, ACT English score, ACT math score, and ACT composite score, identify the one that appears to be the best predictor of cumulative GPA. Explain your reasoning.
Now perform a regression analysis on cumulative GPA, using the predictor variable identified in part (c), as follows.
d. Obtain and interpret a scatter plot.
e. Find and interpret the regression equation.
f. Find and interpret the coefficient of determination.
g. Determine and interpret the three sums of squares SSR, SSE, and SST.
Estimate the flow rate and the average velocity
: A velocity traverse in a rectangular channel that measures 10 cm by 100 cm is represented by the following data. Estimate the flow rate and the average velocity assuming a symmetric plane flow.
|
Explain what events could shift the demand of the labor
: Develop a 7 slide PowerPoint presentation to be presented to the CEO's executive committee that addresses how your chosen organization determines what quantity of labor to demand and what events could shift the demand and supply of that labor.
|
What is the optimal number of servers
: What is the optimal number of servers? - What is the cost for the system, per hour, at the optimal service level?
|
What strategies management use deal with problem of stress
: Describe each of the four categories of stress symptoms for police officers. What are the effects of police stress on officers' health? What are the effects on the health of their families, and on the health of the department? What strategies can ..
|
Find the linear correlation coefficient
: Find the linear correlation coefficient between cumulative GPA and high school percentile for the 200 UWEC undergraduate students in the Focus sample. Repeat part (a) for cumulative GPA and each of ACT English score, ACT math score, and ACT composi..
|
What is the minimum number of servers for the system
: What is the minimum number of servers for this system? - What is the optimal number of servers for this system?
|
What kinds of candidates should your department try to avoid
: As you are recruiting candidates for the department, what types of candidates should you attempt to recruit? What kinds of candidates should your department try to avoid? Are there certain incentives that can be offered to attract highly qualified..
|
Prepare a research paper about current microeconomic theory
: Prepare a 250 - 500 word research paper about current microeconomic thought and theory. Please choose an article from the Wall Street Joumal, The Economist, Bureau of Labor/Statistics, Bureau of Economic Analysis etc.
|
Identify and characterize the hazards
: Conduct a hazard analysis of your community. Based on your analysis, write a 5-10 page paper describing the high and moderate hazards you identified. Follow these steps:
|