Constructing a CDF in Excel 1 Reaction time Cumulative % Count 2 0.1 3 4 5 6 7 8 10 11 12 13 1.07 1.13 1.29 1.33 1.33 1.34 1.36 1.41 1.45 1.63 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1 2 3 4 5 6 7 8 9 10 1. Sort the reaction times from smallest to largest located under the data tab. 2. Label the next two columns 'cumulative %' and 'count' respectively. 3. In the 'count' column fill in '1' in the first cell, '2' in the second, '3' in the third and so forth. It helps to use a formula. Ex. in cell C2 use the formula =C1+1 and then you can drag down. In the 'cumulative %' column, calculate the percentage as the =count/(total number of points). So for the first cell, 'B2', you would have =C2/10 since there are 10 data points in this example. Note: the last cell should always equal one because at the end all of the cells or 100% of the observations are accounted for. 4. Lastly, highlight the reaction time (x-axis) and cumulative % (y-axis) columns and make a scatter plot.

Constructing a CDF in Excel 1 Reaction time Cumulative % Count 2 0.1 3 4 5 6 7 8 10 11 12 13 1.07 1.13 1.29 1.33 1.33 1.34 1.36 1.41 1.45 1.63 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1 2 3 4 5 6 7 8 9 10 1. Sort the reaction times from smallest to largest located under the data tab. 2. Label the next two columns 'cumulative %' and 'count' respectively. 3. In the 'count' column fill in '1' in the first cell, '2' in the second, '3' in the third and so forth. It helps to use a formula. Ex. in cell C2 use the formula =C1+1 and then you can drag down. In the 'cumulative %' column, calculate the percentage as the =count/(total number of points). So for the first cell, 'B2', you would have =C2/10 since there are 10 data points in this example. Note: the last cell should always equal one because at the end all of the cells or 100% of the observations are accounted for. 4. Lastly, highlight the reaction time (x-axis) and cumulative % (y-axis) columns and make a scatter plot.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

in python, Design a Monte Carlo simulation to approximate the value of some number.
Least Squares Regression 1. In MATLAB Write a function to calculate the slope and intercept for a best-fit line using the least-squares linear regression method and to calculate the R2 value. Your inputs should be arrays of X- and Y-values. Your outputs should be the slope and intercept and the R2 value. Section
Match the items on the left with the those on the right. Select the best answer. executing a block of code more than once one-way selection {a = 2; b = ++a; b == a - 1 ? c = 1: c = 0;} sequential flow for (i=0; i y) z = x; else 2 = y: post-test repetition [Choose ] [Choose ] loop instructions are executed one after the other x>y?z=x:z=y: infinite loop increment fixed repetition while loop c=1 binary treet if if-else if-else decrement do-while loop if-else x>y?z-y:z = x; [Choose ] [Choose] D [Choose [Choose
Variable Elimination Elimination order: a,b,x,t,v,s,l Initial factors (products) P(v)P(s)P(t|v)P(1|s)P(b|s)P(a|t,1)P(x |a)P(d|a,b) X. For each variable in the ordering: group together relevant terms Perform summation over these terms, getting a new term. You need to provide the definition of the new term. Insert the new term into the products
Supervised learning example: Iris classificationLet’s take a look at another example of this process, using the Iris dataset we discussed earlier. Our question will be this: given a model trained on a portion of the Iris data, how well can we predict the remaining labels?
Also define First-fit, Best-fit, and Worst-fitalgorithms.
Plot the lines y1 = 2x + 5 and y2 = 9x - 3 in MATLAB. The x-axis should be from -10 to 10.
Given the following UML diagram: Student - studentID: String + getStudentID(): String + toString(): String Person - lastName: String - firstName: String - dateOfBirth: Date - address: Address + getName(): String + getDOB(): Date + getAddress(): Address + toString(): String Professor - employeeID: String +getEmployelD(): String +toString(): String Write an implementation for the class Professor. DO NOT include or implement any constructor for this class. There are no abstract methods/classes in this example. toString method will return any simple String that contains firstName and employeelD only; no less, no more!! Assume firstName was defined as protected in class Person. You are not allowed to add implementation for any class or methods other than what is listed in the question statement.
Please written by computer source benefits of using probability methods versus non-probability methods and the circumstances that would affect whether you chose either collection method. Which collection method do you think is most prevalent in interaction design? Explain your answer.
Hi, I am working on a python question on Pandas. I am trying to figure out the probability of a positive response (1 is a positive response) for each of the groups in the dataframe and then the mean values for each of the groups. I have been trying to do this but I am not sure. Thanks, Adam
How do you do this part in MATLAB? Modify 1. Replace the elements of r_vec with the indices 4, 6, 8, 10 and 15 with 3, 6, 9, 12 and 15, respectively. 2. Replace the elements of mat with the indices (4, 5), (4, 17), (20, 5) and (20,17) with 5, 8, 2 and 9, respectively. 3. Replace the all the elements of the eleventh column of mat with ones. 4. Replace the characters 11 to 19 of chr with the words white cat. 5. Replace the first entry of str with the value of sclr.
Select the most accurate statement regarding RiskOptimizer. It provides the same functionality as the optimization engine included with Excel (i.e., Solver). O It generates results that show the sensitivity of simulation outputs to changes in inputs. O It helps an analyst identify the probability distribution that is the best fit of frequency data. O It can be used to find the values of cells in an Excel sheet that maximize the average profit in a simulation of company operations. O It is a data visualization application that is included with @Risk.