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

Handle me with care karaoke - Water treatment 2 reed bed reading answers - Rainham healthy living centre blue suite - Harold davinier south africa - Robert hughes american visions episode 5 - Week 1 Data Analysis Discussion - Christ alone cornerstone weak made strong - Identify the structures this midsagittal view of a brain model - Genie z45 22 parts manual - ECO 120 Problem Set 2 - Pinewood holiday park narberth - Outline template for persuasive speech - Activity 7.1 - How to calculate quadratic regression - Business Reference - Well writing - Industrial revolution inventions telephone - Disussion - I WANT TO JOIN OCCULT FOR MONEY RITUAL ?.+2349022657119. ✔️ - Pilgrim's progress chapter 1 - Discuss about the FIT2002 Global Treps Project : RACI Matrix. - Saum song bo - Gaia cs umass edu wireshark labs - Budhill family learning centre - Letter to school board from parent - Consistent and inconsistent systems calculator - Flomist nasal spray price at dischem - Starbucks venti social responsibility and brand strategy - Higher ability selection test - God never closes a door without opening a window - Comparative economics in a transforming world economy 2nd edition - According to the rokeach value survey - Societal marketing orientation definition - Content Analysis - 24 hour daycare on tara blvd - The repeated use of the "o" sound in "a host, of golden daffodils" is called - Sas enterprise miner variable roles - Oprah winfrey commencement speech transcript - Winfield refuse management inc case solution - Advanced Business Statistics - The mystery of faith himes pdf - Patient intake and follow up workflow template hcis 140 - Lies my teacher told me chapter 4 - The allegory of the cave painting - Do oak trees grow in australia - HIT System Components - Area of a a4 paper - Merchants of doubt study guide - Your inner fish video guide answers - Driving medical assessment form - Political science - Australian treatment outcome profile - MA GD2 - Mod b essay questions - Epson 212 ink jb hi-fi - My body politic chapter summary - Titans and gods family tree - Urban legend essays - Sea cadet uniform guide - Lansing company cash flows from operating activities direct method - Management information system managing the digital firm edition - Arnold van gennep 3 rites of passage - Olive garden powerpoint - Aims of education ppt - The four i's of transformational leadership pdf - Criminal justice - Process cost summary - Power-Flow Problem - The hoist supports the kg engine - Www cyborlink com besite china htm - Hba training and assessment - Cbc bearings mount gambier - Men's men and women's women steve craig - Research Paper: Introduction - Writing Assignment: Illustration Essay - Scanpan lid knob replacement australia - Nad on physical exam - Pearson brothers recently reported an ebitda of $7.5 million - Muslim Molvi 7340613399 OnLine No 1 FaMOUs VashIKaraN sPecIaLIsT IN Bhilwara - Answers to mathswatch questions - Fast food nutrition assignment - 2013 hsc geography answers - Fat cow motel dvd - Ssd bharat bazar / tandoori express - Market Demand and Pro-forma Income Statement - Allied telesis switch default password - Tell tale heart pdf - Mericans by sandra cisneros pdf - Journal - Changing ways of life - Ebay cost leadership - Lego's turnaround brick by brick case study - Mrs tiresias duffy analysismrs tiresias duffy analysis - Rl circuit lab report - Ecology short answer questions - Franchise or business opportunity venn diagram - Teacher Designated Assessment - Tomo salem nh happy hour - HR_STR (U3_3) - Functional area information systems