Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

All work will be done in one Excel file, multiple worksheets as indicated below Make sure your name is at the top of every EXCEL

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
All work will be done in one Excel file, multiple worksheets as indicated below Make sure your name is at the top of every EXCEL worksheet (type in Cell A1) Complete sentences and proper grammar must be used when reporting all of the answers. Put work and answers for problems 1-5 on a single worksheet - clearly separated, labelled, easy to find and follow. For problems 1 through 5, enter the numbers given in the problem in a spreadsheet, labeled appropriately and then make EXCEL do all of the calculations. Use cell addresses in your calculations as much as possible (see example below). Type answers to questions 6-10 on a second worksheet - clearly separated, labelled, easy to find and follow 1. A student answered 85 problems on a test correctly and received a grade of 92%. How many problems were on the test, if all the problems were worth the same number of points? (Round to the nearest whole number) 2. A math book at the Victor Valley College bookstore originally cost $184 to purchase. If they sell it for $256, what is the percent markup on cost? 3. At Upscale Dress in downtown Tulsa a formal prom dress is selling for $139.99 after a 22% reduction from the original price. What was the original price? 4. The price of a quart of Swallow's Organic Buttermilk has recently increased by 35 percent. The increase brought the price up to $5 per quart. How much was the original price per quart? 5. Lowes in Rancho Cucamonga is having a one-day 20% off sale. The sale price for an exterior door is $288. What was the regular price? 7. Interpret the following histogram House Price Frequency 16 14 12 10 8 Frequency 6 4 0 300 up to 400 400 up to 500 500 up to 600 600 up to 700 700 up to 800 Prices in 3000 8. Sales results for Simple Simon Pies in the last two quarters of 2016 have been recorded and the bar chart below created. Use the bar chart to answer the questions. Till a. Which month has the highest sales? b. Estimate the total sales for the third quarter. c. Find the ratio of December to July sales. 9. Refer to the following breakdown of responses to a survey of "Are you concerned about being tracked while connected to the Internet"? No concern Somewhat concerned Very Concerned a. What is the class with the lowest frequency? b. If 225 respondents answered Very Concerned, approximately how many people took part in the survey

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Global Financial Markets

Authors: Sabri Boubaker, Duc Khuong Nguyen

1st Edition

9813236647, 978-9813236646

More Books

Students also viewed these Finance questions