Question

In: Statistics and Probability

c. Taking every 20th passenger in your sorted table, create a new table that lists Passenger...

c. Taking every 20th passenger in your sorted table, create a new table that lists Passenger ID and Rating for the 20 data points you will now have (In excel please) with formula. I am stomped by this.

TABLE C5-1: PASSENGER ID and CUSTOMER EXPERIENCE RATING
Passenger ID Rating (1-5)
T006 4
T007 5
T008 1
T009 4
T010 5
T011 3
T012 2
T013 3
T014 2
T015 3
T016 4
T017 4
T018 4
T019 5
T020 3
T021 3
T022 2
T023 5
T024 2
T025 5
T026 4
T027 2
T028 2
T029 2
T030 4
T031 5
T032 5
T033 4
T034 1
T035 4
T036 3
T037 2
T038 2
T039 4
T040 5
T041 5
T042 2
T043 5
T044 5
T045 5
T046 4

Solutions

Expert Solution

You can apply the following formulas to the data to form a new table which takes every 20th value.

ROW() gives the row number. It is subtracted by 3 because the table starts from row 3.

The table we get is:


Related Solutions

what are Sorted lists and their efficiency? in c++ and data structures
what are Sorted lists and their efficiency? in c++ and data structures
A Lecturer wishes to create a program that lists his students sorted by the number of...
A Lecturer wishes to create a program that lists his students sorted by the number of theory assignment marks they have completed. The listing should be greatest number of assignment first, sub-sorted by name in lexicographical order (A to Z). A class Student stores the name and marks of assignment completed for a student.                                                    [5 marks] Note: Assume the variable name of collection is list.       i.         Provide a definition of Student with an equals() method. The comparison is based...
How do you sort every 20th customer from excel into a new table. Formula please
How do you sort every 20th customer from excel into a new table. Formula please
In C++ Use vectors instead of linked lists Create a Hash table program using H(key) =...
In C++ Use vectors instead of linked lists Create a Hash table program using H(key) = key%tablesize with Chaining and Linear probing for a text file that has a list of 50 numbers Ask the user to enter the file name, what the table size is, and which of the two options they want to use between chaining and linear probing
Given two sorted lists, L1 and L2, write an efficient C++ code to compute L1 ∩...
Given two sorted lists, L1 and L2, write an efficient C++ code to compute L1 ∩ L2 using only the basic STL list operations. What is the running time of your algorithm?
The following table lists the weight of individuals before and after taking a diet prescribed by...
The following table lists the weight of individuals before and after taking a diet prescribed by a weight-loss company for a month: Weight-loss Data Individual Weight Before (lb) Weight After (lb) Weight Loss (lb) A 126.8 127 -0.2 B 127.4 127.2 0.2 C 130.5 130.5 0.0 D 189.8 190.2 -0.4 E 141.5 141.1 0.4 F 159.2 159.2 0.0 You may find this Student's t distribution table useful in answering the following questions. You may assume that the differences in weight...
The following table lists the weight of individuals before and after taking a diet prescribed by...
The following table lists the weight of individuals before and after taking a diet prescribed by a weight-loss company for a month: Weight-loss Data: Individual: A, B, C, D, E, F Weight Before (lb): 123.7, 128.7, 135.6, 194.9, 145.5, 162.3 Weight After (lb): 109.4, 109.7, 123.3, 186.5, 126.8, 151.5 Weight loss (lb): 14.3, 19.0, 12.3, 8.4, 18.7, 10.8 You may find this Student's t distribution table useful in answering the following questions. You may assume that the differences in weight...
C++ Linked Lists Practice your understanding of linked lists in C++ by creating a list of...
C++ Linked Lists Practice your understanding of linked lists in C++ by creating a list of songs/artist pairs. Allow your user to add song / artist pairs to the list, remove songs (and associated artist) from the list and be sure to also write a function to print the list! Have fun! Make sure you show your implementation of the use of vectors in this lab (You can use them too ) You MUST modularize your code ( meaning, there...
Fill in the table below so that it lists every reagent needed for a PCR reaction...
Fill in the table below so that it lists every reagent needed for a PCR reaction and give its purpose in the reaction. You may or may not need all the rows in this table. Reagent Purpose 5X Taq Buffer F and R primers Supplies co-factor for polymerase Building blocks for new DNA Water
c++ Create a program that creates a sorted list from a data file. The program will...
c++ Create a program that creates a sorted list from a data file. The program will prompt the user for the name of the data file. Create a class object called group that contains a First Name, Last Name, and Age. Your main() function should declare an array of up to 20 group objects, and load each line from the input file into an object in the array. The group class should have the following private data elements: first name...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT