Question

# Please Solve on excel DATA workbook.( I HAVE ATTACHED THE DATA FOR EACH QUESTION- PLEASE ANSWER...

Please Solve on excel DATA workbook.( I HAVE ATTACHED THE DATA FOR EACH QUESTION- PLEASE ANSWER ON EXCEL DOCUMENT)

Xr02-62 A sample of 200 people who had purchased food at the concession stand at Yankee Stadium was asked to rate the quality of the food. The responses are as follows:

Poor

Fair

Good

Very good

Excellent Answer More than 40% rate the food as less than good. Draw a graph that describes the data. What does the graph tell you?

Rating

3

2

1

1

2

3

2

3

3

2

3

3

3

2

2

2

4

2

2

3

1

3

3

3

3

3

3

3

3

3

4

2

3

2

1

2

5

1

3

4

3

5

3

3

3

1

2

3

2

3

3

2

3

2

3

3

3

2

2

2

4

2

3

2

3

4

3

3

3

3

4

4

3

3

2

3

3

1

2

1

3

3

3

3

3

1

4

4

4

1

1

3

2

1

3

3

1

1

2

2

2

2

3

4

1

2

3

4

1

1

2

5

2

3

1

2

3

3

1

1

2

3

3

3

3

3

2

3

3

2

3

3

3

2

3

4

3

2

3

2

3

3

4

1

2

1

2

2

3

2

2

1

3

1

3

2

1

2

4

3

3

3

3

3

2

3

2

5

3

1

4

2

3

2

1

3

5

2

2

1

3

3

1

1

3

2

2

3

4

3

3

3

3

4

2

3

3

3

4

4

#### Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### please answer all the question 1.1 Data that is recorded on a 1 – 5 rating...

please answer all the question 1.1 Data that is recorded on a 1 – 5 rating scale (e.g. 1 = poor, 2 = fair, 3 = good, 4 = very good, 5 = excellent) to a question such as “Rate the level of service you received from your most recent experience with your bank” is: A. nominal data B. continuous data C. interval data D. ratio data E. ordinal data 1.2 A positively skewed histogram means that: A. there are...

• ### can you followed this steps to do a lab report on the (heart). please II. FIRST...

can you followed this steps to do a lab report on the (heart). please II. FIRST PAGE: THIS PAGE SHOULD CONTAIN THE FOLLOWING. IT SHOULD BE NO MORE THAN ONE PAGE LONG A. A STATEMENT OF WHAT YOU THINK IS THE PURPOSE OF THIS LAB B. A STATEMENT OF WHAT YOU LEARNED FROM THIS LAB. obgo C. COMMENTS ABOUT THE LAB: 1. WERE THE DIRECTIONS CLEAR AND UNDERSTANDABLE? 2. WAS THE LAB DOABLE IN THE TIME ALLOWED? 3. HOW WOULD...

• ### please use Excel to answer each question Questions 1-3 Biff Titan, a student at UWO, plans...

please use Excel to answer each question Questions 1-3 Biff Titan, a student at UWO, plans to open a hot dog stand inside UWO's football stadium during home games. There are eight (8) home games scheduled for the upcoming season. He must pay the UWO athletic department a vendor's fee of \$1,600 for the season. The stand and other equipment will cost him \$2,850 for the season. Each hot dog will cost him \$0.61. He has talked to friends at...

• ### Please help me solve this question using Excel data!! (attached on bottom) Thank you!!! Question 2...

Please help me solve this question using Excel data!! (attached on bottom) Thank you!!! Question 2 5 pts Continuing with our data visualization, create a scatterplot with the total number of check-ins (TotCheckins) on the y-axis and the average ratings (AvgRating) on the x-axis. Be sure that the equation for the trend line and the r value are shown on the scatterplot. While your plot may be different aesthetically, which of the following is an accurate representation of the data?...

• ### Please solve using the shown Workbook in excel Balance Sheet & Income Statement Coast Ltd., which...

Please solve using the shown Workbook in excel Balance Sheet & Income Statement Coast Ltd., which has just started trading on 1 January 2019. has the following account balances prior to the recording of the final month of the year: Account Balances as at 30 November 2019 Account \$ Cash \$5 300 Accounts receivable \$6 400 Stock of Supplies \$11 600 Property, Plant & Equipment -cost \$36 000 Accounts payable \$3 000 Interest payable S 100 Bank Loan \$12 000...

• ### View Help Grammarly Tell me what you want to do to edit, it's safer to stay...

View Help Grammarly Tell me what you want to do to edit, it's safer to stay in Protected View. Enable Editing 1. Fifty pro-football rookies were rated on a scale of 1 to 5 based on performance at a training camp. A ranking of 1 is a poor prospect and a ranking of 5 is an excellent prospect. Enter the below data into Excel. Construct a relative frequency and a cumulative relative frequency. Rating Frequency 10 14 18 a. How...

• ### please do BOTH graph 1 And graph 2 on excel please. data is attached Evaporation, mm...

please do BOTH graph 1 And graph 2 on excel please. data is attached Evaporation, mm "ata Table 1: Measured temperatures for just ethanol and 1-propanol. You will be using the data from here to create a graph of Experimental AT versus molar mass Substance T. (°C) T2 (°C) Experimental AT (T.-T2) (°C) 146.07g/mol ethanol 9.2°C 11.6°C 20.8°C 60,09 g/mo 9.5°C 1-propanol 11.5°C 21.0°C Data Table 2: Measured temperatures for the other 4 liquids. You will be using the experimental...

• ### This is project planing and control question,please answer it fully. c. A pharmaceutical company have 4...

This is project planing and control question,please answer it fully. c. A pharmaceutical company have 4 pipeline products in development and have ranked each under 4 relevant headings shown below. Given the following scoring system (Excellent 3, Moderate 2, Poor I) use the weighted scoring method to ascertain the most viable product for further development (6Marks) Product Alpha Beta Gamma Market Potential Excellent moderate Poor Moderate Development Success excellent excellent Moderate excellent Ease of ProductionCompetition Impact poor excellent Moderate poar...

• ### 2. Prior to taking an aerobic lesson, each of the 12 health-club members is asked to...

2. Prior to taking an aerobic lesson, each of the 12 health-club members is asked to rate the instructor on a scale of 3=excellent; 2=good; and 1=poor. Following the class, each student is again asked to rate the same instructor. Given the following before-and-after ratings, can we conclude that there is a significant improvement in instructor's rating at a=0.05. students 1/23/4 5 6 7 8 9 10 11 12 Precourse rating 1 3 2 2 2 2 1 3 1...

• ### I need excel formula to solve it Ha_Zutt 다일 홈 삽입 페이지 레이아웃 수식 데이터 검토...

I need excel formula to solve it Ha_Zutt 다일 홈 삽입 페이지 레이아웃 수식 데이터 검토 보기 도움말 1 제한된 보기 주의하세요- 인터넷에서 가져온 파일에는 바이러스가 있을 수 있습니다. 편집하 ALAB DE Problem 5-26 Perpetuities. Consider the data in the following table. Perpetuity 34 5 6 789 Annual Amount 20,000 100,000 | 3,000 | 60,000 Discount Rate 8% 100 6% 5 % B Determine the present value of each perpetuity. Solution Value of perpetuity A Value of perpetuity B Value...