Click to select the check box for Solver.Xlam. ALSO: The Data Analysis Toolpak was removed in Office for Mac 2008. However, the following is a free third-party tool that offers similar functionality: StatPlus:mac LE: The third-party products that this thread discusses are manufactured by companies that are independent of Microsoft. BioStat user-friendly biology and medicine oriented statistical software.basic statistics,determining descriptive statistics,normality tests,T-Test/Pagurova Criterion/G-Criterion,Fisher F-test,correlation coefficients (Pearson, Fechner) and covariation,ANOVA (MANOVA, GLM ANOVA, Latin squares analysis),regression analysis,multivariate linear.

Review “Simulation Case Study: Phoenix Boutique Hotel Group” for this topic’s case study, in which you provide guidance to Phoenix Boutique Hotel Group (PBHG) founder Bree Bristowe.

In addition to creating a simulation model, prepare a 500-750-word recommendation for Bristowe’s best course of action. Explain your model and the rationale for your recommendations. 2-3 references needed

Use an Excel spreadsheet file for the calculations and explanations. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell). Students are highly encouraged to use the “Simulation Case Study: Phoenix Boutique Hotel Group Template” Excel resource to complete this assignment.

Mac users can use StatPlus:mac LE, free of charge, from AnalystSoft.

Prepare the assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

Subscribe to this site's feed ››
Add to Google Toolbar ››
Submit News ››

Help, Guides, and News on making the Switch To Apple Macintosh Computers

Featured Guides

Macintosh Guides

How to Switch

How to Switch

Recent Articles

Microsoft and AnalystSoft release StatPlus:mac LE data analysis tool for Excel 2008

• site

When Apple redesigned Office for Mac 2008, it had to drop Analysis ToolPak (ATP) because Visual Basic was removed from Office 2008. As a result, Excel 2008 doesn't have data analysis out of the box. Microsoft and AnalystSoft have collaborated to release StatPlus:mac LE, a free download that will provide data analysis options in Excel 2008.

In the Mac Mojo blog, Gavin Shearer states:

'The Mac Excel team and AnalystSoft have been working together for the past several months to tailor StatPlus:mac LE to mirror ATP's functions, and meet the needs of ATP users. We're very, very pleased with the result, and we think you will be, too.'

Therefore, StatPlus:mac LE replaces Microsoft Analysis Toolpak and brings to the table the following capabilities:

• ANOVA
• Correlation
• Covariance
• Descriptive Statistics
• Exponential Smoothing
• F-Test Two-Sample For Variances
• Fourier Analysis
• Histogram
• Moving Average
• Random Number Generation
• Rank and Percentile
• Regression
• Sampling
• t-Test
• z-Test

Now the bad news, the free version doesn't have the full range of functionality offered in the PRO

Statplus Mac Le For Free From Analystsoft Group

version. According to the Mac Mojo blog:

'Finally, as you're using StatPlus:mac LE, you will notice some of the menus are marked with a 'PRO' icon. This designates a function that is available in the commercial StatPlus:mac, but not the free StatPlus:mac LE. If you're in need of a more full-featured analysis solution, consider StatPlus:mac. (It currently has a 30-day trial, and retails for $250; discounts for academic and volume users are available.)'

Head over to the Mac Majo blog post for all the details including download and installation instructions.
I personally know of several switchers who've been annoyed about the lack of ATP support in Excel 2008 and have thus had to instal Windows via Boot Camp or virtually (VMWare Fusion or Parallels) on their Macs in order in order to use Analysis ToolPak (Windows-based Excel). For those still running Excel 2004 on their Mac via Rosetta, this development may encourage them to migrate to Excel 2008 but in our view, Microsoft should have included this functionality when Excel 2008 was released.

Featured Articles

From the Guides

What is Lion?
What is Disk Utility?
What is Boot Camp Assistant?
What is Snow Leopard?
What is Airport Utility?
What is Activity Monitor?
Quickly navigate to the Utilities folder
What are Utilities?
Forward delete on a Mac keyboard
Show or Hide Sidebar items via Preferences
Determine which updates have been installed by Software Update

Statplus Excel

Disable automatic updates in Software Update
Manually run Software Update on Mac OS X Leopard
Different ways to launch a Mac OS X Application
Expose for Apple keyboards that have volume controls on F9, F10, and F11
What is MobileMe Gallery?
What is iWeb?
What is iMovie?
What is iPhoto?

Updated Guides

Statplus Mac Le For Free From Analystsoft 2018

• What is Lion?
  
• What is Mac OS X?
  
• MacBook Pro
  
• MacBook Air
  
• MacBook
  
• Choose Your Mac
  
• The Mac Models
  
• What are Utilities?
  
• What is Disk Utility?
  
• What is Boot Camp Assistant?
  
• What is Snow Leopard?
  
• What is Airport Utility?
  
• What is Activity Monitor?
  
• Quickly navigate to the Utilities folder
  
• Expose for Apple keyboards that have volume controls on F9, F10, and F11
  
• Forward delete on a Mac keyboard
  
• Show or Hide Sidebar items via Preferences
  
• Customize the Sidebar - Hide and Show
  
• Finder and Sidebar - an Ideal Combination
  

RSS Feed · Guides RSS Feed · About · Shop · Privacy Policy · Terms of Use · Best viewed in Safari, Firefox and Internet Explorer 7 or higher
Copyright © 2011 Switch To A Mac · All rights reserved. · All trademarks and copyrights remain the property of their respective owners.