In Excel, 200 values have been entered in cells A2:A201, which has been assigned a name "data". Some of the values are negative, and some positive. In cell c1, I want a single formula that will tell me the 30% percentile of the POSITIVE values only from the A2:A201 range. Select one: O a. =percentile(if(data>0,data),0.3) O b. =percentile(a2:a201,30) O c. =rank(data,0.3) O d. =percentile(if(data>0,data,0),0.3)

In Excel, 200 values have been entered in cells A2:A201, which has been assigned a name "data". Some of the values are negative, and some positive. In cell c1, I want a single formula that will tell me the 30% percentile of the POSITIVE values only from the A2:A201 range. Select one: O a. =percentile(if(data>0,data),0.3) O b. =percentile(a2:a201,30) O c. =rank(data,0.3) O d. =percentile(if(data>0,data,0),0.3)

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

A company approaches you to create an algorithm for calculating the tax and the tip on a restaurant bill. Assume that the application will only tip on the food and beverage total without the tax added in. Your algorithm will allow the user to input the amount of the tip in custom mode or your algorithm will give the tip in 12%, 15%, 18%, 20% recommended increments. Your job is to create the first three steps of the problem-solving process for this algorithm design. Please make sure that you explore the problem space to determine the criteria and constraints in Part 1. Be creative think of all the inputs and outputs you will be using. For Part 2 think of all the questions that you might have in determining how to actually make such a program. And for Part 3 make sure that you specify (pencil and paper – take a picture of it and include it in your document) a couple of examples of your algorithmic process.
Enter your formula in G5 to find out the PRICE under these three conditions: ITEM is "T", SIZE is "L", and COLOR is "R". 1 ITEM SIZE COLOR PRICE 2T 15 ITEM T 3 T M 16 SIZE L. 4 T 17 COLOR R. 5H 28 PRICE 6 H M 29 7 H 30 8 T XL 18 RBR GBBR
Use Raptor to answer the following questions: Shannon and Jasmine bowl as a team. Each of them bowls three games ina tournament. They would like to know their individual averages for theirthree games and the team average. Allow the user to input the scores foreach player. Output Shannon’s average, Jasmine’s average, and the team’saverage. You will need the following variables:Score1 Score2 Score3 avgJasminesumShannon sumJasmine avgShannon teamAvgYou will need the following formulas:teamAvg = (avgShannon + avgJasmine)/2
Slappy’s Software Sales AssignmentYou have been hired by Slappy’s Software Sales to write a program to figure thetotal cost to customers that order Slappy’s software packages.Discounts are given based on the number of units sold:Number of Units Sold Discount Amount1 – 9 None10 – 19 20%20 – 49 30%50 – 99 40%100 or more 50%Create a form similar to this:The three boxes are labels. Remember to use the Auto Size and Border Styleproperties.The program should read the number of units sold and figure a base cost. Theunits cost $99 each. A discount should then be figured and subtracted from thebase cost. The subtotal, discount amount and total cost should be displayed, ascurrency, in the appropriate labels.Here are some screen shots of the running program:Set the tab order and access keys.Put comments in your program as to what each section is doing.Use constants for the discount rates and base price.
Create the following using a raptor flowchart. You are a manager of a Wally's Training Gym and you encourage your trainers to enroll new members. Input is the trainer's last name and the number of new enrollees, and names of each new member. Output is the number of trainers who have enrolled members in each of three categories: 0-5 new members, 6-10 new members, and 11 to 15 new members, as well as the names of each new enrollee. Write an application that allows the user to enter any number Trainer's names, number of new members, and names of each new member. Output is to display the names of trainers who are in each category, and the new members enrolled. Use good programming techniques that you have learned throughout the course. Use appropriate variable names, use an array to store the names and number of new enrollees, and use prompts for the input and labels with the display.
Write one line of code ONLY. Use concatenation to print the variables given below in one line with a space in between: E = "Engineering" %D T= "Technology" Just make sure to precisely match the output format below. Write your code in the ANSWER area provided below (must include comments if using code is not covered in the course). Example Output Engineering Technology