Mean, median and mode are the basic statistics functions which we all have learned in our childhood and no doubt they are extremely easy to find out.
But here is a catch! These statistics functions are actually very easy to calculate but only for those who loves maths or at least they are an average student of math.
Those with the love-hate relationship with maths, find these sums really difficult. But regardless of what kind of a student you have been in school, the computers have answers to every problem including how to find the median, mode and mean.
Exactly, we can do such calculations on our computer systems very easily. The software we will be using for calculating statistics is Excel. Alongside to that, we will also tell you the real method i.e., the old school method of calculating the mean, mode, and median using a notebook and a pen/pencil.
Let’s get started with the tutorial.
How to Find the Median:
There are two ways you can find the mean, median, and mode in maths. The first and very useful method is the stereotype method i.e., using the notebook which we have been doing from our childhood.
Although, there are 100% chances that you know how to find median and mode on the notebook, but you might not know our second method i.e., calculating median and mode on excel.
In this guide, you will get to learn how to find mode and median using both the old school method i.e., using copy/pen and using excel.
How to Calculate Median:
The median is the exact middle number of a set of numbers. Finding out the median of numbers is easy when you have the odd number of total numbers in a set as compared to the even numbers.
The old school method of finding out the Median is as follows.
Step 1. Arrange all the numbers in ascending or descending order. Let’s understand all this by taking an example. Suppose we have a series of the following numbers.
3, 5, 8, 7, 1, 4, 13, 14, 19, 2, 7, 12, 11
The total number of numbers in the set is 13, which is an odd number. Also, the data in the above set is not arranged in any particular order. But in order to find out the median, we need to arrange them in ascending or descending order. We are arranging them in ascending order.
1, 2, 3 ,4, 5, 7, 7, 8, 11, 12, 13, 14, 19
In the odd numbers, finding out the middle value is easy. You can easily judge the middle value in total of 13 is the 7th positioned value. In our case, it’s 7. So the median of the above set of data is 7.
But if we had the even numbers in the series, finding out the Median wouldn’t have been that easy. Suppose we have the following data to find the median of. The series is already arranged in ascending order. But you will have to arrange it if it’s not already arranged in your set of data.
So the series looks like,
1, 2, 3 ,4, 5, 7, 7, 8, 11, 12, 13, 14
Since we have even numbers in the above series, we will have to find out the average of the middle two numbers. In the above series, the two middle numbers are 7 and 7.
The average of these two numbers is (7+7)/2 i.e. 7. So the median of this even numbers of series is 7.
This is the old school method of finding out median. The second and the easiest method to finding out median is in Excel. It will hardly take just a few seconds of yours to get you the results. No need to arrange them in ascending or descending order, just a formula, and BOOM! The result will be on screen.
The steps are like this,
- Open excel sheet on your computer with the series of the data we want to find out the median of. See the following screenshot to checking out the data we will be finding out the median.
- We have 8 numbers in the set. Now click on the cell where you would like to see the result and put the formula =median(A1:H1) and press enter.
A1 should be the cell reference where the series is starting, and H1 should be the cell reference of the last cell in the series. See the below screenshot to find out the median of the above series.
So that’s how we find out the median of the numbers in excel.
How to Find the Mode:
The mode in a series of numbers is the most frequently occurring number. In other words, the mode in a set of numbers is the number which appears the most often.
Finding out Mode in Excel is just a few seconds job. Let’s find out how to do it. Suppose we have the following series of number to find out the mode of.
2, 3, 5, 6, 7, 2, 3, 8, 10, 12, 2
These numbers in the series look’s like the below image.
Now we don’t need to arrange them either in ascending or descending order in excel, just put the formula =Mode(A1:K1). A1 and K1 should be the first and last cell reference in the series respectively. Once you are done putting the formula, just hit enter you’ll see the following result.
So the most occurred number in the series is 2. But if we want to find the mode of the above set of numbers manually using the old school method, we had to arrange them in ascending or descending order first. Like this,
2, 2, 2, 3, 3, 5, 6, 7, 8, 10, 12
Now count the number of times each number appeared i.e. 2 appeared 3 times, 3-two times, and rest of the numbers appeared one time each so clearly the Mode of the series is 2. This method is really time taking and lengthy if we have a large number of series.
We have told you both the ways on how to find the median and mode. Both methods are easy to apply. The first one is good when you have a smaller range of data while the other method applicable to every situation regardless of the range of numbers.
But it’s obvious doing a calculation manually using a notebook, pen, and a calculator is a time taking while doing the same calculation on Excel is far easier and quick.
You can use any of the methods according to your choice!
In the case of any doubt, you can drop your comment below; we will reach out to you as soon as possible!
How to use BitLocker to Encrypt your Files
Locker means a safe place where you can put your personal or important things hiding from others. We all have some things which we don’t want to share with others same as in the computer you have any important data that you want to hide from the outside world. For that, there are many software available over the web and as well as well-known by you so no need to describe it.
But if you want to lock your Hard Drive partitions without any software then? In that case, Microsoft has provided one wonderful tool known as “BitLocker” in Windows Vista, 7 and 8 for encrypting your entire Hard Drive partitions. Using BitLocker you can lock any volume on the computer even the one you boot from. But a question arises in your mind that How to use it, right? So, I will show you two different modes to use BitLocker on your computer. If you wanted to Defrag the Hard Drive, you should see that.
1. “How to use BitLocker on a normal/data volume”
2. “How to use BitLocker on Boot volume”
Let’s see the first mode:
1. How to use BitLocker on a normal/data volume?
A simple way to enable BitLocker – right click on any volume and select “Turn BitLocker on” to start the locking process. After clicking a window will pop-up (as shown in the figure below) asking to enter a password to use with the drive – you will also ask to say a copy of the recovery key somewhere at safe place and then it will begin encrypting your drive.
By this method you can lock all the drives on your computer except “C:/ drive” or “Boot partition”.
Now, the second mode:
2. How to use BitLocker on Boot volume
Yes, it is true that you can encrypt the main operating system drive, but this has some special requirements since the drive has to be unlocked before boot. First of all this requires that Windows has a seperate boot partition that isn’t encrypted; in case if you don’t have then create a separate boot partition. The second requirement is that your system include a TPM (Trusted Platform Module).
If you try to encrypt your boot volume without satisfying the above to requirement then it will give an error as shown in the figure below.
So, in that case you will need to configure your system to use BitLocker with a TPM. Here is how you can do that.
- Press [win + r] and type “gpedit.msc” in it and press enter to launch the Local Group Policy Editor
- Now, browse to – “Computer Configuration > Administrator Templates > Windows Components > BitLocker Frive Encryption > Operating System Drives
- In the right panel. double click the setting “Require additional authentication at startup” and select “Enabled”
- In that please check the below options that “Allow BitLocker without a compatible TPM…” is checked.
- Then, Click Ok – you are done.
Now you will able to start the BitLocker process on your system drive, and will have the option to either enter a password on startup or insert a USB drive to boot.
If you have any problem regarding “BitLocker” then put your comments below so that I can surely help you to get rid out of your problem. Hope this guide helped you to understand how to use BitLocker.
PC taking more startup time? Change the Startup program to boost the startup process in windows 7.
How To Create QR Codes In Easy Steps
In this technology-infused era, everyone wants to have an edge over others. For this, expeditiousness and use of trending technology is a must. Gone are those days when we used to stick to a particular technology for a long period of time.
With the serial advancement, first came the technology of Bar Codes which was derived from the concept of storing some sort of quick information or data in a flat piece. Then came the successor of Bar Codes, QR code (a two-dimensional Bar Code) with some great features.
QR codes facilitated us with the facility of storing data that is very often used such as name, address, contact details, certain URL’s, social media profiles and much more, all confined in a square grid comprising of certain standardized patterns.
See Also: How to Find People on Snapchat
QR codes have revolutionized the way that information is being transfered.
So, let’s dig a little deeper and find out what are QR codes and How to create QR codes in easy steps.
What is a QR code?
Quick Response codes, often abbreviated as QR codes are a kind of matrix Bar Code or two-dimensional Bar Codes (a machine-readable code represented in the form of patterns of parallel lines and numbers usually used to store information’s like price, index of an object to which it is attached ).
QR codes came to us all the way from the technological hub Japan where they were first designed for the automotive Industry.
A QR code uses four industry standard encoding modes to efficiently store information about the item to which it is attached and those are: Numeric, Alphanumeric, Byte/Binary and Kanji (漢字 logographic Chinese character).
A QR code consists of Square dots (black modules) systematically arranged in a square box with a white background and can be read by imaging devices like scanner or camera.
Fact: the QR code system was invented in 1994 by Denso wave (a subsidiary of Toyota) with the sole purpose of tracking vehicles during manufacture. QR codes can store more than 4,000 alphanumeric characters in a limited space.
What purpose are QR codes used for?
QR codes are quite popular in the industry because of its quick readability and larger storage capacity as compared to the usual Bar Codes.
#1: QR codes can be used to link directly to a URL
#2: QR codes can be used to store data like name, address, numeric values like price, phone numbers etc.
#1: One can add QR codes to his/her business cards that could store name, address, contact numbers, links to the social media presence.
#2: QR codes are quite often used in product packaging.
#3: QR codes can be used in print advertisements to boost reach and earnings.
How to create QR codes in easy steps?
See Also: How to Make Emoticons for Facebook?
If you will follow these steps carefully then you will get to know how to create QR codes easily.
Step #1: Search for an online QR code generator. If you will Google it by the keyword “QR code generator”, you will find a plethora of them. Some of them are QRstuff and the QRcode generator. For the sake of instance and simplicity, we will be using QRstuff at first.
Step #2: Select the Data Type (basically the type of information you wanted to convey through the QR code) of the QR code. You can choose from various options like: Website URL, YouTube Video, contact details etc.
Step #3: Type in the details corresponding to the data type which you have chosen.
Step #4: Select the type of color of the QR code. You can select your desired color from the user-friendly multi-color swatch.
QRstuff also facilitates the user to have a preview of the QR code which has been created.
Step #4: Download the QR code. It equips you with the PNG file of the QR code. Moreover, one can even print and E-mail the QR code directly from the website itself.
QR codes created by these methods will work perfectly fine but going with the paid platforms obviously has its perks, here we list some of those perks:
1: you can edit the content without playing with the design of the QR code.
2: you can have multi-user accessibility for managing QR code campaigns.
3: you will be equipped with the facility of tracking the number of scans corresponding to the geography, device and time.
4: you can have the desired resolution, scalar or vector image, format, and quality.
Alternatively, one can also use software for creating QR codes easily.
QR codes work like a charm, You have to see it to believe it. Hope we are efficient enough to make you aware of the basics you need to know while creating you first QR code.
If you have any query regarding QR codes, do let us know via comments. We’ll surely get back to you and will try our level best to solve your thing.
If this piece added some worthwhile value to your knowledge base, then don’t forget to show your appreciation. Do share it on your social media profiles. Thank you for the same in advance.
How to Use uTorrent to Download Files
Willing to get uTorrent movies download files from the internet just at one go? Well, it is the time for you to go and use the uTorrent application. With lots of multiple features for you to use, you can easily download different files from this application just with a click.
All you have to do is learn how to use it and then download the application for further usage. Well, if you do not know the correct process to do it, here is a quick guide for you to go for is you are unaware of How to use uTorrent to download files.
See Also: How to Use BitTorrent Effectively
#1 How to Use uTorrent – Installing The Application
Step 1 The first and foremost thing that you need to do is to install and the downloading process. For Windows PC users, it is recommended that you can download the file from the uTorrent website and then get on with it. However for Android users, you can have a download from the Google Play Store.
Step 2. After you have finished on downloading the file, you now have to continue running the installer. You have to make sure that you are paying attention to every part of installing the file. This is because it will give you the right thing to go for.
Step 3. The next step is of configuring the files and folders with the application. Once you run the software, you now have to configure where to save the files and where not to. This will help you to select the preferences and then customizing the download when you know how to download uTorrent.
Step 4 The next step that you have to cover is to set the bandwidth limits. Once you have covered the previous step, it is now about connecting the ISP with the application. You can do this from the options menu of the application mentioned.
Step 5. The next part will be to enable the protocol encryption. This is the key element to increasing the download speed of your files by hiding the ISP traffic from the application set in the options. You have to select the option of enabling encryption from the mentioned part in the application.
Step 6. Now you have to open the ports of your firewall. You can do this either by going to the default browser which you are using or by giving a click to the option in the application itself. This will help you to run multiple downloads with a high-speed connectivity from the start.
See Also: How to Stream Torrents on iPhone?
#2 Downloading a Torrent File
Step 1. The first thing that you need to do is to find out a torrent file online. However, you can do it easily with the help of different torrent engines which are available online. Selecting the torrent file includes everything from games to software and uTorrent download movies and many more.
Step 2. Examination of the appropriate file to download the torrent should be one of the key things you have to perform. There are terms such as “seeders” and “leechers” which you need to check as well. The more they are means the recent they have been uploaded and as a matter of fact, the better they will help you to download.
Step 3. Viruses are a common thing to catch online and what you have to do is to wait for the comments in the file before you download it. You can choose a file according to the comments mentioned below which will help you to guess which file is safe and which one is not.
Step 4. Once you have now found out the uTorrent download movies for free, you now have to click the download button attached to it. It will help you to download the Torrent file. However, you have to wait for a few seconds to download the file.
Step 5. Next you have to give a double click to the downloaded file to launch it in the uTorrent application. You now have to verify the downloading place and the click on to star download option which is present inside the application.
Step 6. Last but not the least is to check the internet connection. You need to use the internet at the maximum speed for a faster download. This will get the download started in a flash and will end up in downloading the file as quickly as possible.
#3 Monitoring The Download
Step 1. The first thing that you need to do is to check the internet connection. Remember the better is it from your Internet Service provider, the faster the download will happen. If you have a slow connection, do not use the internet for any other purposes at the same time to receive the maximum out of your files.
Step 2. It is now time to check the peers and the connectivity speed. Though the connectivity speed will depend on the time of the sharing of the file, the peers are related to the speed of the internet connection. Thus, you need to be sure in this field of connectivity.
Step 3. Once the download has finished, you can now open it and install the recommended software you were trying to download. However, you have now downloaded the full content which is actually of a much bigger size indeed.
Step 4. Once the download has been finished, you can see an ongoing process of seeding. This seeding actually helps you to upload the recent file of the application and go for it. All you have to do is continue seeding until it finally stops as the other users will get a new file and use the files.
Step 5. The last step of all if you do not want your content to be tracked by other people, you have to install PeerBlock. This helps in keeping your contents safe and does not disclose your IP from getting followed by other members or law enforcement agencies.
This is a complete guide for you on How to use uTorrent to download files. You can now download files from anywhere and just get the job done Even if your device turns off, the download does not go away, it continues from where the file has been left off.
How to Connect Your TV to Your Computer
One way to show digital pictures and video to friends and family is for all to circle around the home computer screen. Alternatively, you can connect your tv to your computer and send the images to the TV. Technology also exists to network a TV and a computer in the other direction, so that you can watch television programs on your laptop or PC.
Showcasing digital images on the television
With a digital camera or video recorder, user can create multimedia image files stored on their PCs. Showing these images to others can be inconvenient, however, especially if your computer screen is small and located in a private room of the house. Displaying them on television usually allows you to show them at a larger size and in a more comfortable location.
You can connect a computer to a TV either wirelessly or with cables. The method you choose depends on the types of connections your TV supports as well as your budget for purchasing additional hardware.
See Also: How to Watch TV Online?
Viewing television on the PC
You may also be interested in watching television programs on a computer. This is also possible with the right wired or wireless equipment installed. Some TV broadcasts are accessible directly via the Internet and no connection to television is required. Those who own Digital Video Recorders (DVR) may also prefer to connect their computer to the DVR rather than the television directly.
Connecting Computers to TVs through Wires
Televisions do not normally support Ethernet cable connections. Instead, you will typically connect your laptop or desktop PC to a TV using one of the following types of audio-visual (AV) cables:
· DVI or HDMI-to-DVI
· Any of the above – to-SCART (in Europe)
A scan converter converts the computer’s video signal into standard TV formats. You may need to set up a scan converter to connect your computer and TV if, between them, the two do not support any compatible combination of AV cable technologies listed above. Latest televisions, however, generally support multiple types of digital inputs and finding the right cable should not be too difficult.
•Connecting Computers to TVs Wirelessly
In place of using cables, you can also use Wi-Fi to connect computers and TVs wirelessly. Since televisions do not ordinarily support Wi-Fi, you will need to install a separate unit between the computer and TV. One common solution is called a Wireless PC to TV system or [i[Digital Media Receiver. These products connect via AV cable to the TV and supply Wi-Fi connections to any computer in the home.
See Also: How To Get Netflix On TV
Another wireless PC to TV connectivity option is based on Windows Media Center Edition (MCE). If you purchase a Windows XP or Windows Vista PC with the MCE application included, this system contains built-in wireless connectivity support for streaming images to your television. A few of these systems also support TV tuner cards that allow your computer to receive incoming television signals. Finally, you can extend the capability of a Media Center PC across an entire wireless home network by installing a Media Center Extender product like the Linksys DMA2100.
Happy computing!! and now you are able to connect your tv to your computer
How To Play PS3 Games On PS4
The Sony Playstation gaming console was launched in the year 1994 and has held gamers enthralled with games ranging from Super Mario Kart to Devil May Cry and BloodBourne.
However, with the ever-increasing complexity of the console from version to version, some games from previous generations are now unplayable. That is up until now. We decided to put together a guide on how to play PS3 Games on PS4 in tribute to the next generation of cloud-based gaming.
Sony PlayStation 4 is one of the premium gaming consoles rivaled only by Xbox One and Nintendo Wii. Being at the pinnacle of the gaming industry for more than two decades now, the PS continues its market dominance much to the delight of Sony PlayStation fans everywhere!
If you wanted to Play Xbox 360 on PC, here is How to Play Xbox 360 Games on PC?
How to Play PS3 Games on PS4
“Can u play PS3 games on PS4?” was the question asked by one of our readers. With the release of Sony Playstation 4 and PS4 not supporting the discs meant for the PS3, this question posed a possible pockmark on the PS4’s otherwise incredible gameplay and performance. So, can you play PS3 games on PS4?
The answer at the time was sadly – No. All the PS3 games stayed with the console for which they were meant. Any disc you bought for the PS3 stays with it, and you will have to get new game discs for PS4.
But, can the PS4 play PS3 games? The answer is yes. Although they both have extremely different internal architectures, PS4 does have the computing power to virtually emulate the PS3 architecture, which makes us think – Why would Sony do this to us?
Give us the computing power, but not the games we all love and adore. Can PS4 play PS3 games? If yes, how?
For those hoping to play PS3 games on PS4, Sony has released Playstation Now, a cloud-based gaming platform that allows you to play all your PS3 games on your PS4 by streaming it to your PS4.
For the gaming community, the PS Now comes as a boon that they had been long awaiting. This allows you to stream games from the cloud and play them in sync with your Sony Entertainment Account savegames. So, say hello to an all-new experience from all your old favorite games from last gen.
Playing the classic vintage games on a new console can be a thrilling experience. The Advanced Graphics rendering and the amazing world texture enhancements make it look more real than the originals did, making the games seem new to the eye. Gameplay remains the same since the control scheme is no different than any previous model of PS.
An interesting thing to note about the PS Now is that it must always be connected, which does provide for some insecurity to those without a stable internet connection. But since all things are based on the cloud for the PS Now, this is a sad thing.
The upside of this is that your savegames will never be corrupted and you can always continue gameplay from the point where you last logged off.
Ever played Fantasy Football? Here is How to Play Fantasy Football?
This somewhat combines the concepts of MMO gaming and traditional gaming with cloud synced savegames for some games like the Batman Arkham Series or Assassins Creed, where you either start where you last left off (out of mission) or in a nearby zone to the place where you can continue the free roam that sandbox games like these give you.
P.S. Now has been in development for some time (since 2014 in fact) and recently released in May of 2015 in North America. Over 400 games are accessible in the cloud for either a monthly subscription of $19.99 or a three-month subscription fee of $49.99.
Does PS4 play PS3 games as well as the original console? The answer is ‘No’ again – Not all games can be emulated and even when they can, it requires a minimum of 5mbps uninterrupted internet speed to preload the game from the cloud. Right now, only 400 of the thousands of games available for the PS3 are available for the PS4, but thankfully almost all our favorite top-sellers are included.
Still, it is a blessing for those praying to the gamer gods for better clearer graphics and amazing gameplay for the games that do run.
Among these are the Assassins Creed Games up till ACIII, Batman Arkham Series (not including Arkham Knight), BlazBlue, Darkstalkers, God of War, Hitman HD remakes, Infamous, Resident Evil, Injustice: Gods among us, King of Fighters ’93 and XIII and several Lego video games including Batman and Harry Potter.
All these are highly recommended if you haven’t played them on the PS3 as well. But any gamer worth his joystick would have played most of these, if not all of them.
PS Now has a 7-day free trial as well, so you can test out how your internet connection responds to the bandwidth load from the cloud games.
Are you a Pokemon fan? You are going to love the Pokemon game on the iPhone. Here is How To Get Pokemon on iPhone
If it does work out, you can then choose to rent games for the standard 4 hours, 1 day, 7 days, 30days and 90 days. Or you can pay the subscription. Either way, it’s awesome, and if you have a PS4 and a decent internet connection – go head and sign up now to get access to all the goodies that Sony PlayStation Now has.
Warning: Side effects may include being unable to get up from your seat, sore thumbs, clawed hands, unblinking eyes and angry moms. If you have suffered from these before (especially the last one), consider keeping maximum snacks and caffeinated fizzy drinks to fight the adverse effects (and do it when she’s away)
We hope this answers the question – how to play PS3 games on PS4 and the question can I play PS3 games on PS4. The PS4 might not be meant for this exclusively, but it sure does meet the requirements of those nostalgic gamers out there with a thirst for adventure, action and adrenalin that only the classics can provide.
How to Access iPhone VPN?
How to Create Personalized Start Button for Windows 8?
How to use BitLocker to Encrypt your Files
How to Reset Macbook Air?
How to Solve Yahoo Mail not Working?
How to Use Apple Thunderbolt Display with PC?
Computers2 years ago
How to Reset Macbook Air?
Tech1 year ago
How to Solve Yahoo Mail not Working?
Mac4 days ago
How to Use Apple Thunderbolt Display with PC?
Tech1 year ago
How to Make a Yahoo Account Without a Phone Number?
iOS1 year ago
How to Stream Torrents on iPhone?
Tech1 year ago
How to Tame a Horse in Minecraft?
Tech1 year ago
How to Receive Money through PayPal?
Windows2 years ago
How to check RAM type (DDR, DDR2 or DDR3) in Windows?