I am wanting to do a t-test in Excel (for a class I am teaching). So as a practice, I did this (in columns A and B):
3413
3523
2329
13200000
14200000
5612
43
These are my two groups, with means:
31.1428571466679.5
Certainly the means seem different!
However, the ttest procedure gave me this p-value:
0.174751284
The formula was this:
=TTEST(A1:A7,B1:B6,2,3)
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies View RelatedI have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
View 1 Replies View RelatedI recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
View 4 Replies View RelatedWhen I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
View 2 Replies View RelatedI was wondering why my Mac Pro under XP Pro is delivering lower scores in the 3DMark tests than PCs with similar specs.
An Intel Core 2 Quad (2.66GHz) with an ATI Radeon HD 3870 x2 and 2GB RAM scores 19137 3DMarks, while my Mac Pro, 2x2-Core Xeon (2.66GHz,) also with a 3870 x2 and 5GB RAM (Windows doesn't use it all - I know) scores a meager 12136 3DMarks (Both 3DMark06.)
I could understand that the Xeons probably aren't as good with games and graphics, but the difference is pretty large.
I get equally poor scores compared to the same computer in the PCMark05 tests. (8299 vs. 5136)
Any guesses to what might be going on?
ALSO: In tests with actual games, my frame rates were lower than comparable systems.
I have a few questions:
When sites do various benchmark tests, they typically use something like 3DMark, and I think Cinebench CPU, etc.
First, I probably got those benchmark apps wrong...which ones do tech sites typically use?
Also, what exactly do these benchmarks exam.
Say I have a rendering application that is processor heavy...what benchmark should I be looking at?
Say I have another application for modeling, and I know it is graphics intensive. What benchmark should I be looking at?
And, to round things out, if I have an application that I know is memory heavy, what stats should I look at.
The reason I'm asking, is when upgrading my computer (at this point RAM), or considering a new MacPro, I want to know I'm buying for the right reasons.
I don't want to buy a powerful computer to find out that its max potential is not fully realized as it relies on something else. Granted I understand a new comp all around will perform better. However, applications such as Maxwell render does not hold back, it will use every processor available (8-cores would be amazing!), but others don't rely on processor, but memory more so.
Even then, I'm not sure all the time how the application performs. With as many apps as I use for different things (Rhino NURBS modeling [XP], Maxwell Render, VIZ/3DS Max, SketchUp, Adobe CS3, CAD) I can't always tell what part of the comp they use.
Thanks [for those who read everything and understand what I'm asking]
Looks like the 2.26 is doing better after all. Some users have even gotten Cinebench scores for the new 2.26 like: 3142 (single) and 20,138 (multiple) reported here.
CINEBENCH 10
This free benchmark app uses real world code from Cinema 4D to render a sample project. It stresses all available cores. In the case of the Nehalem, hyperthreading fools the app into thinking there are 16 cores on the 8-core models and 8 cores on the 4-core models. The graph below shows the Cinebench rating for "Multi-CPU" render test.
GEEKBENCH 2
It's not only multi-core aware, but it includes some memory tests which explains why the Nehalem based Mac Pros beat the older Penryn based Power Macs with higher core frequencies. The graph below shows the overall 32-bit score.
There is also a 64-bit version of Geekbench. Fewer results exist for it since, for some unexplained reason, consumers will gladly spend thousands for a new Mac but resist purchasing a $20 serial number in support of a starving Mac developer.
I'm just wondering if anyone has any recommendations as to how I should test my Refurb Mac Pro (dual 2.26 Octo, GT120, 6GB Ram) as supplied by the online store. I shall be upgrading the RAM, graphics card and hard drives in the near future, but want to check that the machine works correctly out of the box first.
I'm due to take delivery of a U2711 Dell monitor today or tomorrow, and so will be turning this system on for the first time then. I understand that everything should have been thoroughly checked through by an Apple tech at the factory, but the very fact that a refurb store exists means that the quality tests sometimes fail.
I'll be runnung FCS3 from this machine and need the machine to be reliable for paid work, hence the post. I have done a quick search, but only found a thread that was started over 18 months ago, and wondered if you guys had any current advice that could help me. Oh, and I probably should say that I'm new to macs also, so be gentle!!!
I ordered a i7 15" Macbook Pro high resolution anti glare screen over a week ago. I've been reading lots of forums on the subject and have heard about the small print, yellow tint to the bottom half of the screen, the laptop not sleeping etc.
So I contacted the store to find out about the possibility of returning it if I'm not happy. They said I can spend all the time in the store with it but as soon as I leave the store there is a 15% restocking fee. It hasn't arrived yet but I'm expecting it any day now.
Can someone tell me all the tests I can perform in the store before I leave?
So I was curious to see what the difference would be between10.5.1 to 10.5.2
2 gigs of RAM to 6 gigs of RAM
So, when I first got the Mac Pro I ran both Geekbench and Xbench. I haven't tallied the Geekbench results, but the overall scores go like this:
10.5.1 |2 gigs RAM = 7324 | Memory Score = 2486
10.5.2 |6 gigs RAM = 7793 | Memory Score = 2693
I forgot to run Geekbench with 10.5.2 and 2 gigs of RAM.
Attached are the numbers for Xbench. I also graphed them in Numbers. For all those who enjoy this stuff, here you go.
If someone notices something that seems jacked up with these numbers for this system in its various states of configuration, PLEASE let me know!! I'm not savvy with these benchmarking programs.
I just thought some folks out there would like to see the info.The chart can't fit in all the chart titles, so you'll have to look at the raw data to interpret what belongs to what.
Feedback always appreciated. I'm off to finish loading some Windows programs and my games, and then move that partition to the 400 gig drive, and then tell VMware where to go git 'er done!
I'm going to go pick up my Mac Pro from the mailbox right now and I have an SSD and a 1TB Caviar Black waiting to be put into the system. How should hard drives be formatted before installing OSX? And do I format them all the same? Right now I'll have
Boot Drive (SSD)
Data (1TB)
Time Machine (640 that came with Mac Pro)
Also, are there any benchmark tests I should run to see how my system is performing?
If I'm buying a new hard drive, are there any tests/diagnostics I should run on the drive out the box?
View 2 Replies View RelatedI have had FileVault 2 enabled on my MacBook Air (late 2010) and have been running regular disk speed tests using Blackmagic.
This week I bought a new 2GHz Air with 256GB disk and ran Blackmagic, which showed impressive 453/404 MB/s speeds. All well and good. Then I switched on FileVault 2 and decided to repeat the test to see if there was any speed degredation as a result of the encryption. Now I get an error message that the Air's disk is "read only" and Blacmagic cannot run. If I had had problems on the old Air I would have assumed FV2 was the culprit.
Info:
MacBook Air 11, iPad 2, iMac i7, Mac OS X (10.7), iPhone 4
Does anyone know what settings they used in their battery life tests such as screen brightness, what they were doing on the computer etc?
View 2 Replies View RelatedWhen both Mac OS X 10.6 and Windows 7 were tested on a MacBook Pro, Apple's new operating system clearly beat Microsoft in terms of speed, a new test has shown.
Both operating systems were tested on a 2008 MacBook Pro machine by CNet, and each was given its own, separate, clean hard drive. The 64-bit version of each OS was included in the test, which measured a variety of speed and performance related tasks. Snow Leopard was given true, full 64-bit support with most of its native applications taking full advantage of modern processors.
Each OS had the same software installed: iTunes 9, QuickTime, Call of Duty 4: Modern Warfare, and Cinebench R10. In the test, Snow Leopard booted and shut down significantly faster than Windows 7.
"In time-based tests, Snow Leopard consistently outdid Windows 7," the study found. "It took only 36.4 seconds to boot up, while Windows took 42.7 seconds. In a shutdown test, Snow Leopard took only 6.6 seconds, while Windows needed twice the amount of time: 12.6 seconds. Both computers, however, took just about 1 second to return from sleeping. For this reason, I didn't actually test the wake-up time as it was too short in both operating systems to produce meaningful numbers or even allow me to measure the difference."
The Mac software also unsurprisingly ran Apple's own native applications more efficiently. Converting a movie from M4 format to iPod in Quicktime X on Snow Leopard took 444.3 seconds, while Windows 7, with QuickTime 7 (the latest version available) took 723 seconds. Similarly, converting 17 songs in iTunes from MP3 to AAC took 149.9 seconds in Snow Leopard, while Windows 7 required 162 seconds.
The test also found that Mac OS X 10.6 had better battery life on the MacBook Pro than Windows 7. The 2008 model has a removable battery. But author Dong Ngo said he believes Boot Camp drivers were mostly responsible for the Windows 7 battery life, as many PC laptops fared much better than the 77 minutes the Microsoft OS fared.
One area where Windows 7 was able to easily trump Snow Leopard was in graphics performance. The system's 512MB Nvidia GeForce 9600M GT graphics card helped the system score much better in the latest version of Windows, earning a 5,777 3D rendering score in Cinebench R10. Snow Leopard scored 5,437.
In testing Call of Duty 4: Modern Warfare, Windows 7 again came out on top, with an average 26.3 frames per second performance, compared to 21.2 frames per second within Snow Leopard.
Ngo's conclusion: Unless you are a gamer, get a Mac.
"If you can get by with just software designed by Apple and if money is not a big issue, you will be happy with a Mac," he said. "Examples of these software choices are iTunes, iLife, QuickTime, Safari, iChat, and so on (and you probably won't need much more than those for daily entertainment and communication needs). Finally, if money is not an issue--and it definitely is for most of us--you should get a Mac anyway. It's the only platform, for now, that can run both Windows and OS X."
See also:
Windows 7 vs. Mac OS X Snow Leopard
Exploring Windows 7 on the Mac
Inside Mac OS X Snow Leopard
CBS.com is currently testing HTML5 video playback for streaming episodes of its TV shows, signaling that the major U.S. broadcast network aims to be iPad compatible before Apple's new multimedia device launches.
As discovered by MacRumors, accessing "iPad - test" video links accidentally posted by CBS through the iPad simulator, or when spoofing a browser's "user agent" setting, loads a new page that appears to be set up for HTML5 streaming video. The same links take users to the Adobe Flash page when accessed with a traditional browser.
"This new version of the video does not yet work but appears to be based on HTML5," the report said. "The css files reference HTML5 and have a number of 'webkit' specific calls. Webkit is the browser engine used in the iPad's mobile safari. While the videos don't currently play, the 'fullscreen mode' reportedly already works in the iPad simulator."
That CBS would be eager to find compatibility with the iPad should come as no surprise -- the network was on board with Apple's proposal for a TV subscription deal while other networks were wary. The network has also suggested it will lower prices of some TV shows on iTunes to 99 cents, down from the current standard of $1.99.
In February, it was rumored that Hulu, an online streaming video destination for multiple networks, plans to make its videos available without Flash for the iPad platform. Reports then alleged that the Web site could be prepared by the time the iPad launches April 3, though it was said the service would likely be subscription only.
CBS iPad test page, screenshot credit MacRumors.
In January, Google added support for HTML5 in YouTube, the Web's most popular streaming video destination. Allegedly labeled a "CPU hog" by Apple co-founder Steve Jobs, Adobe Flash has been a target of Apple, which has not allowed the Web standard on its iPhone OS, including the forthcoming iPad.
For more on Apple and Flash, and why the Web format will likely never be available on the iPhone OS, read AppleInsider's three-part Flash Wars series.
Long time lurker, first time poster.
I received my 500GB Seagate Momentus XT yesterday and ran some quick and crude benchmarks that I thought I'd share with you guys in case anyone else was thinking of upgrading. Here are my observations.
With Factory Seagate 7200rpm 500GB Drive:
-------------------------------------------
Time to boot measured from hitting the power button to when the finder toolbar appeared at the top averaged approximately 40s to 45s.
Running Photoshop CS5 immedately after reboot took approximately 10s.
The above two tests were repeated about 4 or 5 times and were fairly consistent.
With new Seagate Momentus XT Hybrid Drive:
--------------------------------------------
Time to boot measured from hitting the power button to when the finder toolbar appeared at the top averaged approximately 30s.
Running Photoshop CS5 immedately after reboot took approximately 3s to 5s.
The above two tests were repeated 4 times (sorry I ran out of time to run more) and as expected the first attempt was a little slower than subsequent tests. The times listed above represent the times I was getting after the first reboot.
All in all i'm happy with the improvement, especially when i consider the fact that I still get my 500GB capacity. I wanted an SSD but couldn't bring myself to fork out the money to get a drive with enough capacity to meet my needs.
If you have any questions or want me to run specific tests let me know. Not sure about running battery life tests since my battery-o-meter is all over the place telling me i have anywhere between 2 hours and 8 hours of battery life depending on what i'm doing at any given moment
For some reason, Apple marketing has left out a very import bit of information regarding the sale of Flash based storage. The specs of our flash storage is and was as important as the RPMs off our mechanical drives. As most of you know, shopping for SSDs is like wading through a sea of speed tests. Yet for some reason, Apple is not forthcoming about the IOPS, Read, and or Write speeds of their flash media. There have been endless reports about Toshiba and Samsung based flash media being shipped with iMacs and MBPs with different speeds. I think the earlier brand being a slow dog most of the time.
I called Apple yesterday and got the, we don't have that information sir. I also send an email to feedback explaining that it's probably a good idea to let professionals who are spending nearly 4000$ USD for a rMBP to know the specs of the storage so we can know if it meets our speed needs. With all that said, I welcome all of you to post speed tests of your rMBP. You can do this with 2 tests that I am aware of. If anyone knows of others, please let me know. Please also post your basic model specs, like rMBP 16GB 768GB?
1. Reboot with no apps open
2. Then run Blackmagic Speed Test or AJA System Test
I'm sure the results will not be the same each time you run the test, but over a few tests, you can come up with an average. You might not be able to run the test directly on your drive since Lion has locked us out of our own hard drives, so you might need to pick a folder in your user folder.
I work a lot in Excel for Mac and I have noticed an annoying feature that I can't seem to change. No matter how many times I save a document in "landscape" it keeps on reverting back to "portrait" every time I open it. I have tried to default to landscape but it has not worked.
View 14 Replies View RelatedThere are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? I've tried looking and have come up with nothing so far.
View 12 Replies View RelatedMicrosoft Error Reporting log version: 2.0
Exception: EXC_BAD_ACCESS
Date/Time: 2009-04-20 23:11:30 -0400
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.1.7.090302
Crashed Module Name: libobjc.A.dylib
Crashed Module Version: unknown
Crashed Module Offset: 0x0001568c............
I was wanting to know how to sort a list of birthdays in excel by month and day only (Not including years); I also tried to add only the month and day data but it kept sticking 2010 on the end.
View 1 Replies View RelatedLet's ignore for a moment how awful Microsoft Office products are on a mac. Anyone know how to turn on spellcheck? I don't see it in the preferences.
View 1 Replies View RelatedThird party testing has confirmed that Apple's new 27" iMac can only be used as an external display for devices designed to provide DisplayPort video. It will not work with any equipment that only supports VGA, DVI, or HDMI output.
In a follow-up to its teardown of the 27" iMac last week, iFixit said it revisited the new hardware to see if it could display high-definition video from a non-DisplayPort external source.
The results of the testing indicate that Apple's stated specifications for the iMac were correct; while video input worked as expected with a 13" MacBook Pro equipped with Mini DisplayPort, all attempts to use a physical adapter dongle to supply alternative video signals to the new 27" iMac failed.
"The iMac will not act as a second (or primary) display using the Mini DisplayPort to DVI adapter that Apple sells," the group's website stated. "We tried it on a PS3 Slim, as well as a MacBook and MacBook Pro. It looks like we'll have to wait for a special adapter from Apple or a third party."
A one way street
According to Apple's stated specifications however, the 27" iMac's video input feature will only ever work with DisplayPort devices, and no physical adapter will change that fact.
Apple has frequently used converter dongles on its notebooks in order to support multiple types of video output signaling via the same port. For example, previous notebook models provided Mini-DVI ports proprietary to Apple which could deliver both VGA and DVI outputs using the appropriate connector. These ports provided multiple signaling types over the same physical pins.
Apple's modern machines similarly all supply a Mini DisplayPort connector (originally designed by Apple but now part of the official DisplayPort specification); using the right connector, users can extract and output any video signal type supported by the computer, including VGA, DVI, HDMI, and DisplayPort.
VGA is analog video; DVI and HDMI are both digital, electrically compatible, serial video data formats that only differ in their physical connectors; DisplayPort is an entirely new format that uses a packet signaling format.
The iMac's Mini DisplayPort supports output of all three, but can only input and display DisplayPort video. Unlike moving from DVI to HDMI, converting a DVI signal to DisplayPort requires more than a cheap physical dongle; it would necessitate a relatively expensive converter box to process the signal into a completely new format and possibly also a scaler to match the output device to the 27" iMac's enormous resolution of 2560x1440.
This prevents the new iMac from serving as an HDTV-style output source for older DVI-based computers or HDMI-output devices such as the Playstation 3, Xbox 360, Apple TV, or standard DVD and Blu-Ray players. Future devices that support the DisplayPort standard will work, of course.
Why no DVI or HDMI input is supported
The 27" iMac's inability to input DVI video is rooted in the fact that the DisplayPort specification is uniquely designed to work as both an internal (video card to built-in display) and external (PC to monitor) video signaling system.
Non-DisplayPort systems typically use LVDS for internal video cabling and DVI for external video connectors. No Apple computers supply any sort of internal DVI input to support driving their built-in LCD via the DVI port using an external computer.
Apple's existing MacBooks, Mac mini, Mac Pro, and the smaller new 21.5" iMac model do not support video input at all. The company's 24" LED Cinema Display is the only other device that currently supports (and only supports) DisplayPort input. The 30" Cinema Display HD only supports DVI input, but not DisplayPort.
[ View this article at AppleInsider.com ]
I'm lucky enough to be in Excel 2007 and have infront of me 3 columns of data.
As an example, in the first column is the colour of a product, 2nd = the price, 3rd column = quantity in stock.
Now I know that I can use an array formula to come up with a way of finding out the number of red products that are �2 and have 2 items in stock - unfortunately I am not sure how to do this!
I want to sort out my finance spreadsheet where I have the category of the spending and the adjacent cell is the amount I spent.
[Category, Price]
[Gas , $50]
[Grocery , $80]
[Lunch , $15]
[Gas , $34.50]
What I'd like is for a function that can sort the categories into individual columns for the categories. So that this big list of purchases I have is sorted out into their own column that matches the category and then sums it too. Does this make sense? I was sort of avoiding any VBA for this but if thats how it has to be done then thats cool
Most of my company is PC based, but we artists are Mac based. We all work on the same Excel file, updating, saving, replacing. When we open the PC excel file on our Macs, none of the hyperlinks work ... then if we save something to the file, when the PC guys open the file, none of the hyperlinks work for them anymore either. We really want to be able to use Excel and not have to use VMware in order to update our file on the Mac. Any thoughts??
View 4 Replies View Related