In the accompanying Sales transactions data, use Excels filtering capability to extract:a: all orders that used PayPal b: all orders under $100c: all orders that were over $100 and used a credit card. A1^ xfx RegionD.Amount Product20.85 BookAF.B.Source1.Region2 EastPaymentPaypalWeb3 WestCreditWeb15.25 Book4 NorthCreditWeb24.21 DVD5WestPaypalEmail24.78 Book6 SouthCreditWeb14.65 DVD7 WestPaypalEmail18.67 DVD8 EastCreditWeb178.02 Book9 WestCreditWeb23.86 Book10 WestPaypalWeb| 15.71 DVD11 SouthWeb22.56 DVD12 SouthPaypalEmail24.35 Book13 EastCreditWeb21.45 DVD14 NorthPaypalWeb18.84 DVD15 EastCreditWeb153.94 DVD16 WestCreditWeb| 21.35 Book17 WestPaypalPaypalPaypalPaypalCredit WebWeb22.42 DVD18 EastWeb18.71 DVD19 WestWeb21.14 Book20 NorthEmail17.31 DVD21 West17.27 Book2223242527

Given: The data given is as below Region Payment Source Amount Product East Paypal Web 20.85…

Answered: Source Amount Product Payment Paypal…

Math

Statistics

Source Amount Product Payment Paypal Region East Web 20.85 Book West Credit Web 15 25 Book

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Q: This table summarizes the number of game consoles sold in three areas as of the end of 2010. The…

A: import pandas as pdimport matplotlib.pyplot as plt # Create a DataFrame with the console sales…

Q: Use the following cell phone airport data speeds (Mbps) from a particular network. Find P10. 0.2…

A: Introduction A percentile is a metric that measures up a specific score to the ratings of other…

Q: According to the following ogive graph, find the estimate number of people whos salaries are more…

A: Given ogive graph shows the cumulative frequency (c.f) on y-axis and annual salary on x-axis

Q: Find Q1.

A: solution Given that , 0.2, 0.3, 0.3, 0.4, 0.4, 0.5, 0.6, 0.6, 0.6, 0.7, 0.7,…

Q: For each of the hypothetical data sets, determine whether a bar graph or a pie chart would be an…

A: In general, the most common charts used for visualizing the data are bar charts and pie charts.

Q: Jse the following cell phone airport data speeds (Mbps) from a particular network. Find P50- 0.2 0.2…

A: There are 50 observations. We have to calculate the 50th percentile denoted by P50.

Q: From the following data estimate the number of students getting marks ebetween 20 and 25. Marks…

A: Given, Marks Number of students Below 10 20 Below 20 45 Below 30 115 Below 40 210…

Q: Use the following cell phone airport data speeds (Mbps) from a particular network. Find P70 0.3 0.3…

A: Given the data(x) of cell phone airport data speeds(Mbps) from a particular network.Given data in…

Q: In order to determine the relationship between the number of units sold of a company's product (yy)…

A: From the information, given that Let the independent variable x1 denotes the major competitor's…

Q: firm has been in business only five years, revenue has increased from $308,000 in the first year of…

A: The data values…

Q: Use the following cell phone airport data speeds (Mbps) from a particular network. Find P40 Pa0 =O…

A: From the given data we want to find the value of P40

Q: Each row of the accompanying data indicates the make of vehicles sold at auction in a region in…

A: Pie chart made for categorical variables.

Q: To graphically show the relational order of elements (e.g., business segment categories from most…

A: Scatter plot : It is used to display the relationship between the variables.

Q: 12. The following table shows the average weekly earnings of factory workers for the years 2008 to…

A: The given average weekly earnings of factory workers are as…

Q: company that offers courses to prepare future MBA students for the GMAT exam finds that 40% of its…

A: Here Given P(U)= Probability of undergraduate student=0.4 P(G)=Probability of graduate student=0.6…

Q: VExample 9. Convert the following link relative into price relatives taking 1985 as otse: Year: 1997…

Q: Here are annual revenue data in billions of dollars for the 10-year period 2008-2017 for two…

A: A regression is a technique in statistics that relates a dependent and independent variable. In this…

Q: The bar graph at the right shows the income from summer jobs for six students at a high school.…

Q: A fair coin is tossed 400 times. Find the probability that the number of heads which occur differs…

A: Given information: The total number of tosses is; n=400 and p=0.5.

Q: Mr. Torre, the HRDO Director, surveyed the reasons of the latecomers in the last quarter of 2019.…

A: There are different type of graphs which can be used to represent the statistical data. Some of…

Q: A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that…

A: We have given data as shown in table below Annual Operating Days =250daysAnnual Demand…

Q: If an administrator at a regional hospital wanted to organize the following data, which chart/graph…

A: For (a) we have to use barplot in x-axis diagnosis list and in y-axis we have to take inpatients…

Q: Based on the Bar Graph constructed, give a summary of what the data reveals.

A: Let's delve into the statistical and probabilistic aspects of the data: 1)Mean (Average) Number of…

Q: Use the following cell phone airport data speeds (Mbps) from a particular network. Find Pan 04 0.8…

A: Givensample size(n)=50

Q: A gift shop had overhead expenses totalling $2,779 during the month of July. The business recorded…

A: Overhead rate is calculated by the total amount of sales by total overhead for each department of…

Q: Use the table to answer the following questions. Year U.S population (millions) Traffic…

A: Since you have asked multiple question, we will solve the first question for you. If you want any…

Q: Suppose Ted is creating a football team in a video game that features many NFL players. He decides…

A: We have given that The five data summary Minimum Q1 Median Q3 Maximum 258.0 549.5 743.0…

Q: 10.5 Pe0 =O Mbps (Type an integer or a decimal. Do not round.) 2. 2.

A: I= k*(n+1)/100th term We've to find 60th percentile so k= 60 . There are total 50 Observations. So…

Q: Use the following cell phone airport data speeds (Mbps) from a particular network. Find P20 0.1 0.2…

A: Obtain the Percentile P20. The Percentile P20 is obtained below as follows: From the information,…

Q: For an organisation whose funding in 2006 was above the average would you expect their funding in…

A: Given: 2006 2018 247 240 142 153 124 166 18 40 2 3

Q: All of the following graphs can be used for categorical variables except? Dot plot Bar Graph Pie…

A: The objective is to identify the type of chart that cannot be used for categorical variables.

Q: Use the following cell phone airport data speeds (Mbps) from a particular network Find Po. 0.3 03…

A: Given: n=50 Formula for Percentile: Px=x(n+1)th100term

Q: Use the following cell phone airport data speeds (Mbps) from a particular network. Find P40- 0.1 0.2…

A: Given datasample size(n)=50

Q: The following items represent the number of birds observed at a given feeder over the past several…

A: Given data, 47, 47, 66, 81, 42, 33, 42, 13, 33, 42, 72, 81, 5 The objective is to find the mode…

Q: The bar chart below shows the speed (in gigaflops using a test package) of several processors. It is…

A: In the above graph, the horizontal axis represents several processors. And vertical axis represents…

Q: Create an appropriate chart for the following. (a) The College of Business Administration, showing…

A: (a) The College of Business Administration, showing where their freshmen students came from. Steps…

Q: This question utilizes the BookPrices data set found in the resampledata package. This data set…

A: The data to be used in R is BookPricesThe sample data obtained from R is as followsIt is required to…

Q: Use the following cell phone airport data speeds (Mbps) from a particular network. Find P70. 0.3 0.3…

A: Percentile: The percentile formula is,

Q: 40. House prices: The following table presents prices, in thousands of dollars, of single-family…

A: The question is about measuresGiven :To find :c ) Did the spread increases or decrease ?

Q: The bar graph at the right shows the income from summer jobs for six students at a high school.…

A: As from the bar graph we can see, for the William bar is lower then 2000and higher then 1500 but…

Q: Which of the following are NOT barriers to economic development? civil unrest O high foreign debt O…

Q: World's Richest., Each year,Forbes magazine publishes alist of the world's richest people. In 2009,…

A: Given - n= 5 ∑x= 158 Each year Forbes magazine publishes a list of the worlds richest people…

Q: Use the following cell phone airport data speeds (Mbps) from a particular network. Find P90- 0.1 0.3…

A: The question is about percentiles Given : To find : P90

Q: Describe Four key differences between the activity bar chart and the staff allocation chart.

A: It is important to balance the load among staff members. Team members will need to be able to take…

Question

In the accompanying Sales transactions data, use Excels filtering capability to extract:

a: all orders that used PayPal

b: all orders under $100

c: all orders that were over $100 and used a credit card.

A1
^ x
fx Region
D.
Amount Product
20.85 Book
A
F.
B.
Source
1.
Region
2 East
Payment
Paypal
Web
3 West
Credit
Web
15.25 Book
4 North
Credit
Web
24.21 DVD
5West
Paypal
Email
24.78 Book
6 South
Credit
Web
14.65 DVD
7 West
Paypal
Email
18.67 DVD
8 East
Credit
Web
178.02 Book
9 West
Credit
Web
23.86 Book
10 West
Paypal
Web
| 15.71 DVD
11 South
Web
22.56 DVD
12 South
Paypal
Email
24.35 Book
13 East
Credit
Web
21.45 DVD
14 North
Paypal
Web
18.84 DVD
15 East
Credit
Web
153.94 DVD
16 West
Credit
Web
| 21.35 Book
17 West
Paypal
Paypal
Paypal
Paypal
Credit Web
Web
22.42 DVD
18 East
Web
18.71 DVD
19 West
Web
21.14 Book
20 North
Email
17.31 DVD
21 West
17.27 Book
22
23
24
25
27

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

A number of tools can be used in business process improvement. Of them a __________ is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line.
The following data represents the numbers of stores in the 12 tallest buildings. Find the mode for the following data. 130, 128, 131, 133, 131, 127, 136, 131, 134, 128, 129, 1) O136 128 None of these 131
A congressperson wants to come up with a single value to describe the prices of homes in their district. However, their district consists of a few homes that are extremely expensive compared to the others. Which descriptive statistic should they use? a. Range b. Mode c. Median d. Mean
Use the following cell phone airport data speeds (Mbps) from a particular network. Find Qg. 0.1 0.1 0.2 0.2 0.3 0.4 0.4 0.5 0.50 0.5 0.5 P 06 0.7 0.8 0.8 0.9 1.1 1.2 1.2 1.5 1.6 1.6 2.2 2.3 2.4 2.5 2.8 2.9 3.1 3.7 3.9 4.1 4.3 5.8 7.4 8.1 8.3 8.3 9.1 11.7 11.8 13.4 13.7 14.7 14.7 14.9 15.2 15.2 15.4 15.8 27.9 Q3 (Type an integer or a decimal. Do not round.) Mbps
The following bar graph shows the per capita personal incomes for six states in 2003. Use this bar graph to answer the quèstions. Per Capita Personal Income by State for 2003 39815 40,000 32810 32,000 - 30446 30913 29442 29234 24,000 - 16,000 - 8000 Georgia Florida Delaware Massachusetts Hawaii South Dakota State Step 1 of 2: Find the lowest per capita personal income for the six states shown. Answer 画 Tables 国 Keypad How to enter your answer Keyboard Shortcuts Submit Answer © 2021 Hawkes Learning Income (in Dollars)
Use the following cell phone airport data speeds (Mbps) from a particular network. Find P75. 0.2 0.2 0.3 0.3 0.3 0.3 0.3 0.4 0.5 0.5 O 0.5 0.6 0.7 0.8 0.9 1.2 1.3 1.5 1.7 1.7 1.7 2.2 2.3 2.5 2.7 2.9 3.4 3.4 3.8 4.6 5.6 5.8 7.1 8.5 9.7 10.8 11.1 11.9 12.2 12.6 12.7 12.9 13.3 13.8 14.1 14.8 15.3 15.9 15.9 29.3 P75 Mbps %3D (Type an integer or a decimal. Do not round.)
A small-appliance merchant shows an inventory of 120 Microwave Ovens at a cost of $79.80 and a market value of $79.40. Compute the inventory value at the lower of cost or market. $9,576 $9,528 $9,508 O $9,552
Many countries, especially those in Europe, have significant gold holdings. But many of these countries also have massive debts. The following data show the total value of gold holdings in billions of U.S. dollars and the debt as a percentage of the gross domestic product for nine countries (WordPress and Trading Economics websites, February 24, 2012). Click on the datafile logo to reference the data. Country Gold Value Debt China 63 17.7 France 146 81.7 Germany 203 83.2 Indonesia 33 69.2 Italy 147 119 Netherlands 36 63.7 Russia 50 9.9 Switzerland 62 55 U.S. 487 93.2 Using the entire data set, develop the estimated regression equation that can be used to predict the debt of a country given the total value of its gold holdings. y^ = (to 4 decimals) (to 4 decimals) Gold Value Suppose that after looking at the scatter diagram in part (a) that you were able to visually identify what appears to be an…
The following sales forecast was generated in Excel. What is line C? Sales Revenue $250,000 $200,000 $150,000 $100,000 $50,000 $0 1 wwwww 3 5 Multiple Choice 7 Sales Revenue пик -Forecast( Sales Revenue) Most likely predicted level of sales revenue 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 Highest predicted level of sales revenue Actual sales revenue Lowest predicted level of sales revenue A B C
Use the following cell phone airport data speeds (Mbps) from a particular network. Find P80. 0.3 0.3 0.4 0.5 0.5 0.5 0.7 0.7 0.7 0.7 O 0.8 0.8 0.9 0.9 0.9 0.9 0.9 0.9 1.3 1.4 1.5 1.8 1.9 2.2 2.2 2.5 2.6 2.6 2.9 3.3 3.4 4.6 4.7 5.2 5.8 6.5 7.1 7.1 7.4 7.8 8.8 10.9 12.4 12.6 12.6 13.6 13.8 14.2 14.3 26.2 P80 = Mbps (Type an integer or a decimal. Do not round.) Enter your answer in the answer box and then click Check Answer. All parts showing Clear All Check Answer
Use the following cell phone airport data speeds (Mbps) from a particular network. Find Q₁. 0.1 0.3 0.5 0.5 0.6 0.9 1.1 1.3 1.7 2.6 2.8 2.9 3.9 7.4 8.5 8.6 12.1 14.4 15.6 15.7 0.2 0.7 2.3 4.1 13.3 0.2 0.9 2.4 5.4 13.6 0.2 0.9 2.5 5.5 13.7 Q₁ = Mbps (Type an integer or a decimal. Do not round.) 0.4 1.1 2.7 8.4 15.3 0.5 1.5 3.7 8.6 15.7 6685 0.6 1.6 3.8 ܣ 9.5 25.6
Use z scores to compare the given values. Based on sample data, newborn males have weights with a mean of 3224.6 g and a standard deviation of 739.9 g. Newborn females have weights with a mean of 3027.5 g and a standard deviation of 473.6 g. Who has the weight that is more extreme relative to the group from which they came: a male who weighs 1700 g or a female who weighs 1700 g? Since the z score for the male is z= and the z score for the female is z= the has the weight that is more extreme. (Round to two decimal places.)