Toolkitpak Installation sequence:

CLICK GO:

2007 T Test:

• Go to the DATA ribbon
• Select the DATA ANALYSIS MENU (below)

To do data analysis in Excel, you have to install add-in “Analysis ToolPak” on

Office Icon (left top corner) –> Excel options –> Add-Ins : highlight “analysis ToolPak” and click GO button

then we will have ‘Dana Analysis’ icon on Analysis group on DATA tab

CORRELATION COEFFICIENT

The correlation coefficient between two series, say x and y, equals

Covariance(x,y) / [Sqrt(Variance(x)) * Sqrt(Variance(y))]

where

• Covariance(x,y) is the sample covariance between x and y:  (1/(n-1)) × Σ _i (x_i – xbar)(y_i – ybar)
• Variance(x) is the sample variance of x: (1/(n-1)) × Σ _i (x_i – xbar)²
• Variance(x) is the sample variance of y: (1/(n-1)) × Σ _i (y_i – ybar)²

CALCULATION USING THE DATA ANALYSIS ADD-IN

This requires the

LittleBrother is watching you

Source: http://www.scu.edu/ethics/publications/iie/v9n2/brother.html

If you happen to be reading this article online from your computer at work, your boss may be reading over your shoulder-electronically. New technologies allow employers to check whether employees are wasting time at recreational Web sites or sending unprofessional e-mails. But when do an employer’s legitimate business interests become an unacceptable invasion of worker privacy?

By Miriam Schulman

Last year, a software package came on the market that allows employers to monitor their workers’ Internet use. It employs a database of 45,000 Web sites that are categorized as “productive,” “unproductive,” or “neutral,” and rates employees based on their browsing. It identifies the most frequent users and the most popular sites. It’s called LittleBrother.

Though the title is tongue-in-cheek, LittleBrother does represent the tremendous capabilities technology has provided for employers to keep track of what their work force is up to. There are also programs to search e-mails and programs to block objectionable Web sites. Beyond installing monitoring software, your boss can simply go into your hard drive, check your cache to see where you’ve been on the Net, and read your e-mail.

Did you delete that message you sent about his incompetence? Not good enough. The e-mail trash bin probably still exists on the server, and there are plenty of computer consultants who can retrieve the incriminating message.

All told, such monitoring is a widespread-and-growing-phenomenon. Looking just at e-mail, a 1996 survey by the Society for Human Resource Management found that 36 percent of responding companies searched employee messages regularly and 70 percent said employers should reserve the right to

to learn a basic concept about WIKI, see this video: http://www.youtube.com/watch?v=-dnL00TdmLY&feature=related

then watch this basic TWIKI tutorial: http://www.youtube.com/watch?v=nUapWzlwpDk&feature=related

or in this site: http://www.twiki.net/twikitutorials.html

How to use TWIKI for a company: http://www.youtube.com/watch?v=ZRQgKlX-bOA&feature=related

We can DELETE or EDIT or CREATE range Names at

FORMULAS tab –> “Defined Names” Group –> NAME MANAGER

Simple IF (two conditions)

In Excel, the If function returns one value if a specified condition evaluates to TRUE, or

Yakni dengan melihat selisih nilai R kuadrat pada variable yang diprediksi jika Predictor yang ingin dianalisis TIDAK DIIKUTKAN

Only when

Pertanyaan dan jawaban ini dikumpulkan dari berbagai forum statistika, saya memilihnya krn pertanyaan nya menarik dan jawabannya cerdas:)

1. Tanya:
kenapa

Seringkali kita ingin membandingkan antara dua populasi, apakah kedua populasi tersebut sama atau berbeda untuk nilai variable tertentu.
Misal: kita ingin menjustifikasi bahwa Nilai mahasiswi di jurusan saya lebih tinggi dari Nilai mahasiswa.

Nah…biasanya kita nggak mungkin mengambil data dari semua populasi, sehingga kita hanya mengambil sample dari masing-masing populasi.

Bagaimana kita membandingkannya??

Biasanya kita membandingkan nilai dua kelompok data dengan

Saya selalu bilang ke anak saya, Mulia: “Mulia…semakin sering kamu latihan sepakbola, semakin pinter kamu main sepakbola“.

dari kalimat nasehat saya ini, benernya saya udah bikin asumsi adanya hubungan (korelasi/correlation/relationship/association) antara

Frequency latihan sepakbola –> Kemampuan sepakbola

Benarkah??

Gimana sih caranya