Question: Please answer this question using the data in Data Set 1. If an item is Blue in color OR Large in

Please answer this question using the data in "Data Set 1".

If an item is "Blue" in colorOR"Large" in size, its "Promotion Unit Price" is calculated asUnit Price * 0.5 + 500. Otherwise, the Promotion Unit Price of the item is the same as its unit price.

How many different products have a"Promotion Unit Price" that are more than $5000?

Hint: One possible approach to find the answer is as follow:

In a new column, use IF() and OR() functions together to calculate the new unit price. (Use Google to search forExcel "OR Function" "IF Function"for manual or examples).
Use COUNTIF() to count the number of Promotion Unit Price that met the condition specified in the question.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Please answer this question using the data in "Data Set 1". If an item is " Blue " in color OR " Large " in size, its " Promotion Unit Price " is calculated as Unit Price * 0.5 + 500 . Otherwise, the...

Instructions: 1.0 - The Data We'll be looking at a data set (collected in 2009-10) called theHappyPlanetIndex. It has 143 countries and the following variables: CountryName of country Region1=Latin...

Please answer the question based on the case study below ! 1. what are the most important strategic benefits that Pfizer derives from it's vertical Integration strategy? 2. over the long term, how...

Forecasting at Hard Rock Cafe With the growth of Hard Rock Cafe from one pub in London in 1971 to more than 163 restaurants in 68 countries today came a corporatewide demand for better forecasting....

Please answer this question in detail. Will leave a rate! 1. A cereal manufacturer makes its own toy-prices, which are then put into its boxes. While the toy- price manufacturing process is...

Please answer all of the following questions. Chapter 4 questions Question 1 The Accounting Cycle - How do the different steps affect the financial statements? What is the effect on the financial...

Demand and Supply Discussion Question: Applications-Ubereconomics Please read the article below and respond to the follow-up question: Using Big Data to Estimate Consumer Surplus: The Case of Uber...

PLEASE READ QUESTION CAREFULLY. You have to do in LISP language not in any other language. 2). The interesting thing about LISP is that not only is it typeless, but it easily confuses code with data....

Please answer this question: Are plant-based meat substitute products just a fad? Also, how likely is it that a large percentage of the worlds population will switch from eating animal meats to...

please answer the question below Virgin Galactic LLC (Virgin Galactic), founded by Sir Richard Branson, owner of the Virgin Group Ltd., was a space tourism company headquartered in California. In...

The test scores on a 100-point test were recorded for 20 students: a. Use an appropriate graph to describe the data. b. Describe the shape and location of the scores. c. Is the shape of the...

(a) Use the continuity and normalization conditions to evaluate the coefficients A and C in the deuteron wave functions. (b) From the resulting wave function, evaluate the root-mean-square radius of...

Dashboard / My courses / DSC 1 5 2 0 - 2 5 - EX 0 6 / Welcome Message / DSC 1 5 2 0 - Exam Ma what is the second derivative of g ? g ( x ) = x 1 0 - 1 0 x 5 1 6 a . d 2 g d x 2 = 1 0 x 9 - 5 0 x 4 b...

A box contains 30 red balls, 30 white balls, and 30 blue balls. If 10 balls are selected at random, without replacement, what is the probability that at least one color will be missing from the...

A company that produces fine crystal knows from experience that 10% of its goblets have cosmetic flaws and must be classified as "seconds." a. Among six randomly selected goblets, how likely is it...

A wallet contains five $10 bills, four $5 bills, and six $1 bills (nothing larger). If the bills are selected one by one in random order, what is the probability that at least two bills must be...

A mutual fund company offers its customers several different funds: a money market fund, three different bond funds, two stock funds, and a balanced fund. Among customers who own shares in just one...

At a certain gas station, 40% of the customers use regular gas (A1), 35% use plus gas (A2), and 25% use premium (A3). Of those customers using regular gas, only 30% fill their tanks (event B). Of...

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Segment Reporting Recycle Corporation has provided you with the following information about its operations for the past year: 1. The paper recycling division of Recycle Corporation reported operating...

Segment Information Broadline Company has 4 major product lines. In the United States, it produces refrigeration equipment and disk drives for computers. It also produces stereo equipment in Korea...

Using Ratios to Analyze Liquidity You have received the following financial information of Morrow Company and Valley Enterprises: Before investing in either company, you have decided to use ratio...