Also see: How to get free Microsoft Office 2016 We’re using Excel 2013 here, but it’s the same or similar in other versions. How to calculate standard deviation in Excel: the basics Let’s say you have a column full of data. All you need to do to calculate the standard deviation is select an empty cell on your spreadsheet, type =stdev(a1:a20) and you’ll get your answer instantly. This assumes that your data is numerical values in cells A1 to A20....

But when you’re away from home and you aren’t signed into your own apps, you’re using an old TV without support for the latest apps, or the content you want to display is owned by you or within a phone-focussed app like TikTok, there are other solutions that will be preferable. You can connect your Android phone or tablet to a TV wirelessly or using a cable. We’ll outline your options below....

Our step by step guide explains how to find out the IP address of your PC, iPhone, iPad or Android device. An IP address is the number which makes a device identifiable on a network. Compters, network printers, smartphones, tablets, media streamers and all other devices on your home network have an address in the format 192.168.1.10. The first two numbers should always be the same for home networks, but the third may be different depending on your router....

Spotify Free vs Spotify Premium Spotify’s £9.99/$9.99 Premium subscription lets you listen to all of the 30 million+ tracks available, as well as podcasts and videos. You’ll be able to travel abroad with your music, get on demand mobile access and the ability to listen offline. You’ll also have unlimited skips and no ad interruption. However, there is a ad-supported option, called Spotify Free, which (you guessed it) is completely free of charge....

The controls let you set an overall time limit, or limits for various types of activity, such as games & apps, reading, watching videos and more. They also have a Bedtime function that makes the tablet unusable between the bedtime hours you set. There are alternative ways to limit screen time, though. We recommend apps such as Qustodio. This runs on all your child’s devices and lets you block apps in real-time as well as limiting how much time they can use specific apps for....

In general, Windows 10 handles so-called ‘high-DPI’ well and automatically adjusts elements and text so they’re a normal size. This means that even if you have a 15in laptop with a 4K screen – 3840×2160 pixels, Windows should appear the same as on a screen with one quarter of the resolution – or less. But if you find that text is too small or too large on your screen, regardless of its resolution, here’s how to find the setting to change it....

How to publish a book or eBook: preparation Another thing to consider at this stage: you will need a cover. A full-sized cover at 300dpi. Again, this may be something it is worth outsourcing if you have limited design skills. Don’t think the cover isn’t important. A good, professional-looking cover could mean the difference between a sale and no-sale. People do judge books by their covers. On a similar vein you should prepare marketing copy to promote your book....

Before we jump straight into the process of registering online, it’s worth checking if you’re eligible in the first place. We don’t want you to waste your time. Can I vote in the general election 2017? Age For starters you need to be old enough to register which means being 17 in England, Northern Ireland and Wales. However, you can’t place a vote until you are 18. In Scotland you can register to vote if you are 15....

See all Android tutorials. How to directly reply to notifications in Android To get started you’ll need to download and install the free quickReply app from Google Play. Launch the app, accept the licence agreement, then tap on ‘Please Activate quickReply’. Under Notification access slide on the toggle next to quickReply to give it access to your notifications. You’ll be asked whether you’re sure you want to do that, so click Ok....

Rooting will definitely spice things up a little bit and will give you complete control to access your phone’s internal system files. So in our today’s tutorial, we’ll be discussing some easy steps on how to root and install TWRP recovery on Moto E 2014 (condor) 1st Generation smartphone. Motorola Moto E was released in 2014 with some decent specs and features including a 1.2GHz Qualcomm Snapdragon dual-core processor, 1 GB of RAM, 4 GB of internal storage, 5-megapixel camera, and much more....

The good news is that there are apps which can declutter and clean up the Registry, removing leftover stuff that hasn’t been removed when apps were uninstalled, and fixing things. They are much safer that poking about manually. Back up the Registry before you start Before you do anything, it’s crucial to ensure you back up the Registry first.. There is a good reason why it’s not immediately obvious how to access the Registry within Windows....

Best ebay tips and tricks 1) First things first: take lots of good photos. People will be able to tell the difference between stock images and the genuine article, and showing the item as-is will give them confidence in its condition, so make sure they’re good quality. Also, it’s now free to add up to a dozen. Bonus! 2) Similarly, the item details are very important. No one’s going to buy your items if they can’t find them, and giving eBay all the information you can will help your stuff show up in searches....

The Steam Link is designed to be easy to setup, but the included Quick Start Guide is pretty uninformative – it’s basically just a diagram of two different hardware setups, with no real instructions. There are a few different configurations to think about, and a couple problems you might run into along the way, so read on to find out how to set up the Steam Link and how to enable in-home Steam streaming....

Make sure you have a look at our top iOS tips and tricks to get the most from your phone. While this has been available on other services such as Waze and Citymapper for some time, the transition to Google Maps makes it that much more accessible and easy to use for everyone as Google Maps comes as standard for most phones. This new update also allowed ETA sharing for several popular third-party apps, such as WhatsApp and Facebook....

Because these are common (or known) types of file, Windows doesn’t display the .doc or .mp3 by default as it deems the additional information unnecessary. This is far from ideal though, as it can quickly lead to confusion especially if you have multiple format versions of the same file name or when you want to change the file type itself. The reason the latter is an issue is that it’s easy to think you’re changing the extension by editing the file name, for example changing July Report to July Report....

To remedy this issue, we’ve split our tutorial into platform-specific sections covering PC, console and mobile versions of Minecraft to help you learn to teleport and get where you’re going in the blink of an eye. Teleporting in Minecraft on PC A word of warning: it’s possible that, if you don’t type the coordinates correctly, you could teleport yourself into solid ground. This would result in you quickly losing health and death will follow soon after....

Here are a few handy tips on how to trace an IP addresses to check out the people and organisations you’re dealing with. For more ways to protect yourself be sure to also read How to use a VPN to stay safe online. What is an IP address? IP stand for Internet Protocol and is web-shorthand for the unique number that identifies your router from the rest of the internet....

With well over 1 billion users, there’s a huge audience for people to tap into, especially when you consider the likes of Stories and IGTV in addition to regular posting. Instagram is still overwhelmingly mobile-focused, although most of its key features have now made their way onto the desktop website. The most glaring exception is the ability to post directly from your PC or laptop. However, there is a workaround on Windows, with the help of some third-party software....

We’ve found it works pretty well but aside from looking nice, it brings quite a few benefits for players. One is that certain types of Pokémon appear more often for that type of weather. Second, those Pokémon are more powerful than usual, so will have higher CPs (and other values). It’s also worth catching ‘boosted’ Pokémon as you’ll get 25 percent more stardust, which is always worth having. The final benefit is that Pokémon you’ve already caught are around 20 percent more powerful when battling if the weather is right for them....

Samsung users either use the Smart Switch app or the update checker in settings. But, both of these methods are not always convenient to get the latest Samsung mobile software. This is when users prefer the third-party platform to download the firmware.tar.md5 files. Furthermore, these users then use the Odin Flash Tool to update their Samsung Galaxy device. Apart from that, these firmware download tools use stolen decompiled code from SamFirm....