Ask DBMS Expert


Home >> DBMS

(For questions 1 - 5): There are many variables in Stat_Grades.sav that can be used to describe the students in the dataset. Use the variable Ethnicity and answer the following questions:

1. Using the Variable View in SPSS (lower left), write out how Ethnicity is labeled, and note how many Ethnicity categories are included.

2. What type of data and level of measurement does the Ethnicity variable represent: Is the data discrete or continuous? Is the data qualitative or quantitative? Is the data nominal, ordinal, ratio, or interval?

3. Use SPSS to output the mean, median, and mode for the Ethnicity. Include the SPSS here. Which of the three descriptive numerical measures of central tendency (mean, median, or mode) BEST describes the variable Ethnicity? What information does the measure tell you about the students in the dataset (Stat_Grades.sav) - be specific?

4. Which of the three descriptive numerical measures of central tendency (mean, median, or mode) LEAST (or most poorly) describes the variable Ethnicity? Explain.

5. Choose the most appropriate graph to represent the variable Ethnicity. (There is more than one possible answer). Create the graph in SPSS and include it here. Be sure the graph is fully labeled. Does this graph confirm what the mode tells you about this dataset? Explain.

6. What type of data and level of measurement does the Final Exam Points variable represent: Is the data discrete or continuous? Is the data qualitative or quantitative? Is the data nominal, ordinal, ratio, or interval?

7. Use SPSS to output the mean, median, and mode for the Final Exam Points. Include the SPSS here. Which of the three descriptive numerical measures of central tendency (mean, median, or mode) BEST describes the variable Final Exam Points? What information does the measure tell you about the students in the dataset (Stat_Grades.sav)?

8. Which descriptive numerical measure of central tendency is LEAST appropriate to describe the variable Final Exam Points? Use SPSS to output ONLY that one numerical measure. Include it here. Why is that numerical measure the least appropriate? What information does that measure tell you about the students in the dataset (Stat_Grades.sav)?

9. Choose the most appropriate graph to represent the variable Final Exam Points. Create the graph in SPSS and include it here. Be sure the graph is fully labeled. Discuss why you chose this graph type and what it tells you about the students in the class.
(For questions 10-13): Relationships (correlation) between variables.

10. List all five quizzes, and include for each quiz, the numerical measures of mean, range, and variance. Explain what these measures tell you about the quizzes as compared to each other. On which quiz did students appear to perform the best? Which quiz had the lowest performance? Which quiz had the highest variance (variation in scores) and what does that tell you about that quiz? (100 word minimum, fully explain, include SPSS).

Fill in this table, include the SPSS, and then explain and answer the other questions.

11. Looking at the relationship between each of the Five Quizzes and the Total Points: First, use SPSS to measure the relationship (correlation) between each Quiz and the Total Points. Include all five r -values here. Which of the five Quizzes has the strongest relationship (correlation) with the Total Points, and how do you know? Which of the five Quizzes has the weakest relationship with the Total Points, and how do you know?

Quiz 3 has the strongest relationship with the Total Points variable, since the correlation value of 0.83 is the closest to 1 or -1. Quiz 5 has the weakest relationship with the Total Points variable, since the correlation value for Quiz 5 is 0.65, which is the closest to 0 of the five correlation coefficients.

12. Use SPSS to create the scatterplot for the Quiz and Total Points that had the strongest relationship. Paste the graph here. What does this graph show or tell you? Is it linear? Is the slope positive (going upwards) or negative (going downwards)? Does it seem like doing well on the Quiz relates (or correlates) to doing well on the Total Points?

13. Will a low score on the Quiz cause a student to get a low value on the Total Points? Explain. (50 word minimum)

14. Which two variables are being investigated and label each variable as either dependent or independent.

15. The Correlation Coefficient (or r-value) is used to measure the relationship between any two variables. In this case, what is the r-value?

16. What does the r-value and the scatterplot tell you about the relationship between these two variables? Is the relationship positive or negative? Is it strong, medium, or weak?

17. Suppose a student has a previous GPA of 3.20. Using the scatterplot, what is a good estimate of what their Final Exam Points?

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91844537
  • Price:- $45

Priced at Now at $45, Verified Solution

Have any Question?


Related Questions in DBMS

Data mining assignment -in this assignment you are asked to

Data Mining Assignment - In this assignment you are asked to explore the use of neural networks for classification and numeric prediction. You are also asked to carry out a data mining investigation on a real-world data ...

Sql query assignment -for this assignment you are to write

SQL Query Assignment - For this assignment you are to write your answers in a word document. This assignment is in three parts: Part A (reporting queries), Part B (query performance), Part C (query design). For this assi ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

Objectivethe objective of this lab is to be familiar with a

OBJECTIVE: The objective of this lab is to be familiar with a process in big data modeling. You're required to produce three big data models using the MS PowerPoint software. This tool is available on UMUC Virtual Deskto ...

The relation memberstudentid organizationid roleid stores

The relation Member(StudentId, OrganizationId, RoleId) stores the membership information of student joining organization. For example, ('S1', 'O2', 'R3') indicates that student with Id 'S1' joined the organization with i ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Relational database design a given the following business

Relational Database Design A) Given the following business rules, identify entity types, attributes (at least two attributes for each entity, including the primary key) and relationships, and then draw an Entity-Relation ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Data model development and implementationpurpose of the

Data model development and implementation Purpose of the assessment (with ULO Mapping) The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain unde ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As