Prompt: For all Excel Practice assignments, submit only ONE Excel document but answer each question on separate worksheets within the document.
Chapter 17: Data Set 1 contains the data for a group of participants who took a timed test. The data are the average amount of time the participants took on each item (Response Time) and the number of guesses it took to get each item correct (Number Correct).
What is the regression equation for predicting Response Time from Number Correct? Use the SLOPE and INTERCEPT functions to create the equation. (Worksheet 1)
What is the predicted Response Time (Y variable) if the Number Correct is 8? (Worksheet 1)
What is the difference between the predicted and the actual Response Time for each of the Number Correct scores, and what is the standard error of estimate or prediction? (Worksheet 1). Use How to Perform Simple Linear Regression in Excel:
(Links to an external site.)
Using the following data, test the question of whether an equal number (hypothesized proportion) of Democrats, Republicans, and Independents voted during the most recent election. Test the hypothesis at the .05 level of significance.
Political Affiliation Observed
Republican
Democrat
Independent
800
700
900
On Worksheet 2, perform a chi-square test on the data using the video:
(Links to an external site.)
or
(Links to an external site.)
(This is building an excel spreadsheet on different pages)
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|