Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel 2016 in practice ch 9 guided project 9 3

18/03/2021 Client: saad24vbs Deadline: 2 Day

xcel 2016 Chapter 8 Exploring Data Analysis and Business Intelligence Last Updated: 4/20/18 Page 1

USING MICROSOFT EXCEL 2016 Guided Project 8-3

Guided Project 8-3 Courtyard Medical Plaza has new worksheets for weight loss workshops. You use Solver with sample data and add

scenarios and data tables to complete a sample set. You also create PivotTables to analyze dental insurance data.

Skills Covered in This Project • Create and manage scenarios.

• Use Solver in a worksheet to find a solution.

• Build a one-variable data table.

• Build a two-variable data table.

• Create and customize a PivotTable.

• Insert a slicer in a PivotTable.

• Insert a PivotChart.

• Generate Descriptive Statistics for a set of data.

This image appears when a project instruction has changed to accommodate an update

to Microsoft Office 365. If the instruction does not match your version of Office, try using the alternate

instruction instead.

1. Open the CourtyardMedical-08 workbook and click the Enable Editing button. The file will be

renamed automatically to include your name.

2. Install Solver and the Analysis ToolPak.

a. Select the Options command [File tab].

b. Click Add-Ins in the left pane.

c. Click Go near the bottom of the window.

d. Select the Solver Add-in box.

e. Select the Analysis ToolPak box.

f. Click OK.

3. Click the Workout Plan worksheet tab and select cell E10. Five activities are included in this plan to

burn calories for weight loss. This cell includes a SUM formula.

4. Add scenarios in a worksheet.

a. Click the What-if Analysis button [Data tab, Forecast group] and select Scenario Manager.

b. Click Add.

c. Type Basic Plan as the name.

d. Click the Changing cells box, select cells D5:D9, and click OK.

e. Do not edit the Scenario Values and click OK.

f. Click Add to add another scenario.

g. Type Double as the name, keep the

Changing cells as is, and click OK.

h. Change the values to 2, 2, 4, 2, 2, doubling

each current value, in the Scenario Values

dialog box and click OK (Figure 8-96).

i. Click Close.

5. Use Solver to find a target calorie burn.

a. Click the Solver button [Data tab, Analyze

group].

b. Select cell E10, the cell with a SUM formula,

for the Set Objective box.

c. Click the Value Of radio button and type

3500 in the entry box.

d. Click the By Changing Variable Cells box and select cells D5:D7. Solver finds how many times

each activity should be performed to burn 3,500 calories subject to the constraints.

Step 1: Download start file

Excel 2016 Chapter 8 Exploring Data Analysis and Business Intelligence Last Updated: 4/20/18 Page 2

USING MICROSOFT EXCEL 2016 Guided Project 8-3

6. Add constraints to a Solver problem.

a. Click Add to the right of the Subject to the Constraints box.

b. Select cell D5 for the Cell Reference box.

c. Choose >= as the operator.

d. Click the Constraint box and type 2. The constraint requires that the exercise be done at least

twice a week.

e. Click Add to add each of the five remaining constraints shown here:

D5 <=4

D6 <=3

D6 >=1

D7 <=4

D7 >=1

f. When all constraints are identified,

click OK in the Add Constraint

dialog box.

g. Choose GRG Nonlinear for the

Select a Solving Method.

h. Confirm that the Make

Unconstrained Variables Non-

Negative box is selected (Figure 8-

97).

i. Click Solve. A solution displays in

the worksheet, and the Solver

Results dialog box is open.

7. Save Solver results as a scenario.

a. Click Save Scenario in the Solver

Results dialog box.

b. Type 3500 Burn as the scenario

name.

c. Click OK to return to the Solver

Results dialog box.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Financial Assignments
Assignment Hut
Fatimah Syeda
Coursework Helper
Accounting & Finance Mentor
Math Exam Success
Writer Writer Name Offer Chat
Financial Assignments

ONLINE

Financial Assignments

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$24 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

I have read and understood all your initial requirements, and I am very professional in this task.

$48 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$35 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$163 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$51 Chat With Writer
Math Exam Success

ONLINE

Math Exam Success

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$156 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Haverwood furniture case b - Logical Structures of Arguments Essay - Boutiqaat group for perfumes and beauty - An olympic high jumper leaps over - Why are business transactions initially recorded in a journal - Barefoot moneymovement org au - Fundamental financial accounting concepts edition answersb - What is the solution to mc003 1 jpg - Sam hughes margaret olley - Fina Markets and Institutions - Print network diagram ms project - Uni of greenwich portal - History of proctor and gamble - What are universal gates explain - Explain how enterprise applications improve organizational performance - Wildfit reviews - Attachment theory and social work values - The danger of a single story analysis essay - Book review the prince by niccolo machiavelli - What is walt disney's mission statement - Sutton coldfield college design centre - Slumdog millionaire burning eyes - Corrugated flute take up factors - BA Assignment - Theatrical backdrops crossword clue - Diagnostic Skill Application II - What happens to fleance in macbeth - Molander corporation is a distributor of a sun umbrella - WEEK 10 DISCUSSION - Assignment OM - Week One Study Guide - Speech Delivery - Livingston company is a wholly owned subsidiary of rose corporation - Tic tac toe android source code download - How to play deal or no deal in the classroom - Current Topic 3 - Leaders - Mgm holdings share price - When did hitler become chancellor - Amey sheffield olive grove - Literary analysis paper - Assignment 8 - Discuss professional nursing leadership and management roles that have arisen - Critical response essay - Language techniques in lord of the flies - The us airline industry case study - Pearsall v alexander - Australian steel design code - Planning and the marketing mix simulation backpack - St matthew from the gospel book of charlemagne - Global Climate Change writing assignment - Classics 2220 osu - Solution mechanics of materials rc hibbeler - Can a priest be a confirmation sponsor - Multisim export to excel - Nec graded project - Leadership in Healthcare Organization W5 Project - Argumentative essay about How is biodiversity important to a thriving planet? What are the dangers of the high rate of species extinction that the planet is facing? What are the proposed solutions to this problem and how effective will they be? - Tis the season to be jolly mp3 - Discussion(TM) - Judaism is the only civilization that had its roots based on the logocentricity of life? - Security architecture 10.1 - John radcliffe women's centre - What is case history in audiology - ANNOTATED BIBLIOGRAPHY - Naeyc key messages on the position statement - Beyond twinkle twinkle using music with infants and toddlers - Rose rosenfeld freedman - Continuous function on a closed interval - Theysayiblog - Business analytics implementation plan for a design firm - Separating sand and salt lab report - 27.1 feeding and digestion workbook answers - Http www press uchicago edu books turabian turabian_citationguide html - Part2 - The madoff affair questions and answers - What is the unit of analysis in quantitative research - What percentage is a 4 on the ap exam - Uti care plan goals - 1-2 page paper - Financial Planning - Go go go said the bird - Cisco 2960x stack configuration guide - Flemings trees top 10 - The main theme of this essay mother tongue suggests that - Edit My Paper Narrative Paper - Each place value in a binary number represents ____ raised to the appropriate power. - Point of view worksheet answers - Studycorgi: A Trustworthy Resource for Finding the Best Essay Writing Services - 2016 ap test dates - Reading summary phi - Can great white sharks swim backwards - Beowulf as an epic - How to unstick oil pressure relief valve - Sister lucy's powdered face - 11 seater troop carrier - Www universalteacher org uk - Ap biology multiple choice questions and answers 2015 - Wileyplus exercise answers - Role of the Nurse Practitioners - Beowulf and the dragon parallels and analogues