When cleaning survey data, start with the software, version and data sources required by your course. Only then choose between Windows, macOS and ChromeOS. Microsoft documents Power Query for Windows, Mac and the web, but the available features and data sources may vary by version. Next, match the memory to your files and weigh the benefits of a larger screen against the space you have on your desk and the need to carry your laptop around.
Who is this laptop guide for?
Student using prescribed analysis software
You want to know whether the software and Excel features for your assignment will work with the operating system and version you choose. Microsoft Support covers Power Query in Excel for Windows, Mac and the web. Also check that it supports the specific data sources and features you need.
Student working with larger survey datasets
You work with larger files and want to match memory and storage to your workload. Posit recommends considering extra RAM for datasets larger than 1 GB; that doesn’t mean 16 GB is automatically essential for every RStudio user.
Student splitting their time between their room and lectures
You work at a small desk and take the same laptop with you. Screen space, weight, battery life and ports all involve trade-offs. ASUS notes that students often take their laptops to lectures or other places to work.
What should you look for?
Windows laptop
Choose this option: if your course requires Excel for Windows or specific Windows software.
Bear in mind: check the exact software version, the data sources you need and whether it’s compatible with an Arm processor.
MacBook
Choose this option: if the required programmes and tasks work with your version of macOS and Excel.
Bear in mind: Microsoft Support covers Power Query in Excel for Mac, but don’t assume it offers the same features and data sources as Windows.
Chromebook
Choose this option: only if you can complete the entire assignment using approved browser-based applications.
Bear in mind: confirm in advance that you won’t need to install any required desktop software locally.
Start with the software and file sizes, then compare screen size, portability and what you’ll need alongside your laptop. Microsoft Support outlines how Power Query features and data sources vary by Excel version. Posit recommends considering extra memory for datasets larger than 1 GB.
| What to consider |
What to look for |
Who is this most important for? |
| Software compatibility |
Check the operating system, software version and required data sources. |
If I need specific software or Excel features for my course, I want to know in advance whether they’ll work. Around 29% of consumers prioritise software compatibility. |
| Memory and files |
Match the memory to the size of your files and the tasks you’ll be doing. |
With larger datasets, I want to avoid underestimating my workload. Around 23% of consumers prioritise file and data processing. |
| Desk space and portability |
Compare the screen size and resolution with the space on your desk. Also check the weight, battery life and ports you need. |
If I work at a small desk and take my laptop to lectures, I want a practical balance between screen space and portability. Around 18% of consumers prioritise this combination. |
| Total cost and support |
Check whether a charger is included and how you’ll access the required course software. |
I want to know before buying which accessories and software I’ll still need. Around 18% of consumers focus mainly on cost and support. |
| Data protection |
Check the rules for access and storage if your files contain personal data. |
If my survey files contain personal data, I want to know who can access them and how to store them in line with my course requirements. Around 12% of consumers prioritise data protection. |
Avoid common buying mistakes
-
Choosing a Chromebook based on a general student laptop ranking
A general ranking won’t tell you whether the desktop software for your assignment works on ChromeOS.
First, check whether you can complete every required step using approved browser-based applications.
If not, you may need access to another computer or working environment.
-
Assuming Power Query works the same way on every system
Microsoft covers Power Query for Windows, Mac and the web, but the available data sources and features vary by version.
Check which Excel version, import sources and tasks your assignment requires.
-
Looking only at the laptop itself
For the HP ProBook 4 G2a 16-inch version DW5S1EA#ABH, HP Netherlands states that the charger is sold separately. This doesn’t necessarily apply to other versions.
Check what’s in the box and how you’ll access any required course software.
You may need to buy a separate charger for this specific version.
Brands to consider
Acer
The Aspire 17 A17-51M-53T4 is worth comparing if you’re considering a larger screen.
- A larger screen can be useful for spreadsheets, if you have enough desk space.
- Check the specifications of the exact version you’re considering; don’t rely on the model name alone.
Apple
A MacBook Air is a compact macOS option, provided you’ve confirmed that your course software and Excel tasks work with your configuration.
- Microsoft Support also covers Power Query in Excel for Mac.
- Check that it supports the features and data sources your assignment requires; portability alone doesn’t mean it’s suitable for your software.
ASUS
The CM14 Flip is a ChromeOS option to consider if you’ve confirmed that your workflow works in a browser.
- ASUS lists ChromeOS for the CM14 series.
- Check the memory and storage configuration of the exact version and whether you can complete your assignment without desktop software.
HP
The ProBook 4 G2a 16-inch version DW5S1EA#ABH is an example to consider if screen space matters to you.
- For this version, HP lists 16 GB RAM, a 512 GB SSD and a screen resolution of 1920 × 1200.
- HP states that the charger for this version is sold separately; these specifications don’t apply to every ProBook.
Dell
The Dell Pro 14 Plus PB14255 is an example of a Windows laptop with a more compact screen.
- For the configuration in question, Dell lists a 14-inch screen, 16 GB memory and a 512 GB SSD.
- Check the exact version, as configuration choices can change the specifications.
Windows laptops at Joybuy
These Windows laptops are options for students who want to work with survey files and spreadsheets in their student room. Compare their memory, screen space and weight with the requirements of your assignment and the space you have to work.
No image available
HP OmniBook 5 Flip 14-fp0075nd C5VM5EA#ABH
A Windows laptop for studying and working in different places. Check that it’s compatible with the course software you need.
Windows 11 Home, 16 GB memory, 512 GB SSD and a 14-inch screen with a resolution of 1920 × 1200. The listed weight is approximately 1.62 kg.
A compatible USB-C charger of at least 45 W is not included and must be purchased separately.
View at Joybuy
No image available
HP OmniBook 3 16-by0058ndx
A 16-inch Windows laptop to compare if you’d like more screen space for spreadsheets.
Windows 11 Home, 8 GB memory, 512 GB SSD and a screen with a resolution of 1920 × 1200. The memory cannot be upgraded, so more RAM may be useful for larger datasets.
The charger is not included and must be purchased separately.
View at Joybuy
No image available
ASUS Vivobook S16 S3607QA-SH109W
A 16-inch Windows laptop to compare if you’d like a larger screen for spreadsheets.
Windows 11 Home, 16 GB LPDDR5X memory, 512 GB SSD and a 16-inch WUXGA OLED screen. The product name lists a Snapdragon X processor.
View at Joybuy
No image available
Lenovo V15 G5 IRL
A Windows laptop with 16 GB memory to compare with the requirements of your analysis software and files.
Windows 11 Pro, 16 GB DDR5 memory, 512 GB SSD and a 15.6-inch Full HD screen. The product name lists an Intel Core i5-13420H processor.
The listed starting weight is 1.61 kg.
View at Joybuy
No image available
ASUS Vivobook 18 M1807HA-S16512W
An extra-large screen may suit spreadsheet work if you have enough desk space. Also bear the weight in mind if you’ll be carrying it around.
Windows 11 Home, 16 GB memory, 512 GB SSD and an 18.4-inch screen with a resolution of 1920 × 1200. The listed weight is 2.60 kg.
A power adapter is not included; a suitable 45–65 W USB-C Power Delivery charger is required.
View at Joybuy
Frequently asked questions
Do I always need 16 GB RAM for RStudio?
No. Posit doesn’t recommend a fixed amount of memory for every RStudio user. Your needs depend on the analyses you run; for datasets larger than 1 GB, Posit recommends considering extra RAM. Compare this with the files you use and the way you work.
Can I carry out my Excel data-cleaning tasks on a Mac?
Power Query is also available in Excel for Mac. Before buying, check that your version of Excel supports the data sources and tasks in your assignment. The fact that Power Query is available doesn’t, by itself, confirm this.
How should I set up my laptop if my surveys contain personal data?
Follow your course’s rules on storage and access. The Dutch Data Protection Authority gives access controls and device security as examples of measures. What’s appropriate depends on how the data is processed and involves more than just a feature on your laptop.
What if a laptop I bought online isn’t right for my assignment or breaks down soon after?
For online purchases by consumers in the Netherlands, you often have 14 days after delivery to change your mind, subject to legal exceptions. ACM ConsuWijzer also explains that your statutory guarantee is separate from the manufacturer’s warranty: if a product doesn’t meet reasonable expectations when used normally, the seller is responsible for providing an appropriate solution.