$233.00 $873.00 Frequency Restaurant Sales Date Day Lunch Sales $ Dinner Sales $ Delivery Sales $ 24-Apr Tuesday $233.00 $523.00 $411.00 Fill all values highlighted in Neon Yellow 3-Apr Tuesday $289.00 $646.00 $321.00 17-Apr Tuesday $298.00 $572.00 $365.00 (a) 10-Apr Tuesday $307.00 $579.00 $328.00 Min amount (Lunch Sales) | 25-Apr Wednesday $341.00 $731.00 $243.00 Max amount (Lunch Sales)| 19-Apr Thursday $345.00 $913.00 $294.00 (b) 4-Apr Wednesday $354.00 $782.00 $289.00 Bins 27-Apr Friday $379.00 $1,409.00 $1,143.00 11-Apr Wednesday $387.00 $664.00 $301.00 200 5-Apr Thursday $403.00 $805.00 $276.00 250 12-Apr Thursday $412.00 $891.00 $243.00 300 18-Apr Wednesday $419.00 $621.00 $278.00 350 26-Apr Thursday $426.00 $940.00 $350.00 400 6-Apr Friday $442.00 $1,289.00 $1,242.00 450 7-Apr Saturday $449.00 $1,652.00 $782.00 500 20-Apr Friday $467.00 $1,332.00 $1,254.00 550 14-Apr Saturday $503.00 $1,581.00 $714.00 600 13-Apr Friday $508.00 $1,178.00 $1,068.00 650 31-Mar Saturday $542.00 $1,468.00 $884.00 700 28-Apr Saturday $592.00 $1,856.00 $601.00 750 21-Apr Saturday $622.00 $1,732.00 $636.00 800 8-Apr Sunday $697.00 $1,209.00 $341.00 850 15-Apr Sunday $741.00 $1,137.00 $326.00 900 29-Apr Sunday $779.00 $1,229.00 $398.00 22-Apr Sunday $846.00 $1,324.00 $319.00 (c) 1-Apr Sunday $873.00 $1,345.00 $489.00 Plot (d) Comments/Observations
$233.00 $873.00 Frequency Restaurant Sales Date Day Lunch Sales $ Dinner Sales $ Delivery Sales $ 24-Apr Tuesday $233.00 $523.00 $411.00 Fill all values highlighted in Neon Yellow 3-Apr Tuesday $289.00 $646.00 $321.00 17-Apr Tuesday $298.00 $572.00 $365.00 (a) 10-Apr Tuesday $307.00 $579.00 $328.00 Min amount (Lunch Sales) | 25-Apr Wednesday $341.00 $731.00 $243.00 Max amount (Lunch Sales)| 19-Apr Thursday $345.00 $913.00 $294.00 (b) 4-Apr Wednesday $354.00 $782.00 $289.00 Bins 27-Apr Friday $379.00 $1,409.00 $1,143.00 11-Apr Wednesday $387.00 $664.00 $301.00 200 5-Apr Thursday $403.00 $805.00 $276.00 250 12-Apr Thursday $412.00 $891.00 $243.00 300 18-Apr Wednesday $419.00 $621.00 $278.00 350 26-Apr Thursday $426.00 $940.00 $350.00 400 6-Apr Friday $442.00 $1,289.00 $1,242.00 450 7-Apr Saturday $449.00 $1,652.00 $782.00 500 20-Apr Friday $467.00 $1,332.00 $1,254.00 550 14-Apr Saturday $503.00 $1,581.00 $714.00 600 13-Apr Friday $508.00 $1,178.00 $1,068.00 650 31-Mar Saturday $542.00 $1,468.00 $884.00 700 28-Apr Saturday $592.00 $1,856.00 $601.00 750 21-Apr Saturday $622.00 $1,732.00 $636.00 800 8-Apr Sunday $697.00 $1,209.00 $341.00 850 15-Apr Sunday $741.00 $1,137.00 $326.00 900 29-Apr Sunday $779.00 $1,229.00 $398.00 22-Apr Sunday $846.00 $1,324.00 $319.00 (c) 1-Apr Sunday $873.00 $1,345.00 $489.00 Plot (d) Comments/Observations
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
For the Restaurant Sales database,:
(a) Obtain the Min and Max amount in sales
(b) For each Bin shown in the excel sheet, calculate the frequency for each bin as follows:
For ex: if the Bin value is $200, the frequency is the number of entries, whose sales are Less than or equal to 200.
Next Bin value is $250 => Frequency is the number of entries, whose sales is >200 and less than or equal to 250.
And so on….
(c) Now that your values for Frequency and Bins is complete, use any data visualization tool/chart to plot – Sales on the X axis and Frequency on Y axis.
(d) Looking at the plot /graph/chart in (c), what do you infer about the relationship?
Transcribed Image Text:$233.00
$873.00
Frequency
Restaurant Sales
Date
Day
Lunch Sales $ Dinner Sales $ Delivery Sales $
24-Apr
Tuesday
$233.00
$523.00
$411.00
Fill all values highlighted in Neon Yellow
3-Apr
Tuesday
$289.00
$646.00
$321.00
17-Apr
Tuesday
$298.00
$572.00
$365.00
(a)
10-Apr
Tuesday
$307.00
$579.00
$328.00
Min amount (Lunch Sales) |
25-Apr
Wednesday
$341.00
$731.00
$243.00
Max amount (Lunch Sales)|
19-Apr
Thursday
$345.00
$913.00
$294.00
(b)
4-Apr
Wednesday
$354.00
$782.00
$289.00
Bins
27-Apr
Friday
$379.00
$1,409.00
$1,143.00
11-Apr
Wednesday
$387.00
$664.00
$301.00
200
5-Apr
Thursday
$403.00
$805.00
$276.00
250
12-Apr
Thursday
$412.00
$891.00
$243.00
300
18-Apr
Wednesday
$419.00
$621.00
$278.00
350
26-Apr
Thursday
$426.00
$940.00
$350.00
400
6-Apr
Friday
$442.00
$1,289.00
$1,242.00
450
7-Apr
Saturday
$449.00
$1,652.00
$782.00
500
20-Apr
Friday
$467.00
$1,332.00
$1,254.00
550
14-Apr
Saturday
$503.00
$1,581.00
$714.00
600
13-Apr
Friday
$508.00
$1,178.00
$1,068.00
650
31-Mar
Saturday
$542.00
$1,468.00
$884.00
700
28-Apr
Saturday
$592.00
$1,856.00
$601.00
750
21-Apr
Saturday
$622.00
$1,732.00
$636.00
800
8-Apr
Sunday
$697.00
$1,209.00
$341.00
850
15-Apr
Sunday
$741.00
$1,137.00
$326.00
900
29-Apr
Sunday
$779.00
$1,229.00
$398.00
22-Apr
Sunday
$846.00
$1,324.00
$319.00
(c)
1-Apr
Sunday
$873.00
$1,345.00
$489.00
Plot
(d)
Comments/Observations
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education