Legit Processor Reviews

Intel Core i5-750 and Core i7-870 Processors

Manufacturer: Intel
Product: Intel Core i5 and Core i7-800 CPUs
Date: Tue, Sep 08, 2009 - 12:00 AM
Written By: Nathan Kirsch -
Share:

Microsoft Excel 2007

Microsoft Office Excel 2007 is a powerful and widely used tool with which you can create and format spreadsheets and analyze and share information to make more informed decisions. It allows you to import, organize and explore massive data sets within spreadsheets and then communicate your analysis with professional-looking charts. Excel 2007 also provides tools to “see” important trends and find exceptions in your data. Legit Reviews has two benchmarking tests that we do on Microsoft Office Excel 2007.

Microsoft Excel 2007 Testing

The first workload executes approximately 28,000 sets of calculations using the most common calculations and functions found in Excel. These include common arithmetic operations like addition, subtraction, division, rounding and square root. It also includes common statistical analysis functions such as Max, Min, Median and Average. The calculations are performed after a spreadsheet with a large dataset is updated with new values and must re-calculate many data points. The input file is the 6.2 MB spreadsheet seen above.

Microsoft Excel 2007 Benchmark Results

Benchmark Results: Lots of people use Microsoft Office at work and home, so this is an important test for many of our readers. Many people don't run 28,000 sets of calculations at once, but if you do the CPU will determine how fast the task is completed. 

The Black-Scholes model is used in our second Excel test to calculate a theoretical call and put price using the five key determinants of an option's price: stock price, strike price, volatility, time to expiration, and short-term (risk free) interest rate.

Microsoft Excel 2007 Testing

This workload calculates the European Put and Call option valuation for Black-Scholes option pricing using Monte Carlo simulation. It simulates the calculations performed when a spreadsheet with input parameters is updated and must recalculate the option valuation. In this scenario we execute approximately 300,000 iterations of Monte Carlo simulation. In addition, the workload uses Excel lookup functions to compare the put price from the model with the historical market price for 50,000 rows to understand the convergence. The input file is a 70.1 MB spreadsheet and with 10 times the calculations of the first test; this one should take a bit longer to complete.

Microsoft Excel 2007 Benchmark Results

Benchmark Results: With 300,000 iterations of Monte Carlo simulation taking place in this benchmark it takes all the processors a bit longer to finish as it puts a good load on the system. The new Lynnfield processors again do well in this benchmark with the Intel Core i7 870 processor being the fourth fastest that we have ever benchmarked.

Next Page - Cinebench R10


Review Index
Page 1 - Intel Launches Two New CPU Series and a Chipset
Page 2 - The Core i7-870 and Core i5-750 CPUs
Page 3 - The P55 Express Chipset
Page 4 - The Test System
Page 5 - Temperature Testing
Page 6 - Overclocking the Core i7 870 CPU
Page 7 - Sandra 2009 Memory Bandwidth
Page 8 - Photodex ProShow Gold 3.2
Page 9 - Microsoft Excel 2007
Page 10 - Cinebench R10
Page 11 - POV-Ray 3.7 Beta 25
Page 12 - POV-Ray Real-Time Raytracing
Page 13 - Futuremark 3DMark06
Page 14 - World in Conflict
Page 15 - Power Consumption
Page 16 - Final Thoughts and Conclusions