Data Analysis Day 2

Data Analysis Day 2 - Data Analysis (Day 2) Solver Allows...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Analysis (Day 2) Solver Allows you to optimize a model based on objectives, variables, and constraints Solver is an Excel add-in, and must be installed o To install Solver: File – Excel Options – Add-Ins (select “Solver Add-in” and click Go, and then click OK) Once installed, Solver will appear in the Data tab automatically o To open Solver: Data – Analysis – Solver Random Number Generator There may be instances in which you will need a random number or a series of random numbers Random number functions: o RAND – has no arguments; returns a random number (note that the random number will change every time the workbook recalculates) o RANDBETWEEN – specify the range of values that you want to be considered, and the function will return a random integer within that range Random Number Generator: o Part of the Data Analysis Add-In o To install the Data Analysis Add-In: File – Excel Options – Add-Ins (select “Analysis ToolPak” and click Go,
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/02/2011 for the course ACIS 2504 at Virginia Tech.

Page1 / 2

Data Analysis Day 2 - Data Analysis (Day 2) Solver Allows...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online