Blog - Page 13 of 27 - nandeshwar.info

How to Perform Linear Regression in Excel

These instructions read better in this Linear Regression Excel Directions PDF file Linear Regression in Excel Introduction Linear regression is a statistical technique used to observe trends, determine correlation, and predict future observations. The underlying principle of this technique is called the least-squared, which is the process of minimizing the distance between the predicted value […]

What is Data Analytics or Data Science and How to Learn them for Free

UCLA‘s professor Jason Frand defines data mining as this: “data mining (sometimes called data or knowledge discovery) is the process of analyzing data from different perspectives and summarizing it into useful information – information that can be used to increase revenue, cuts costs, or both” To become an expert and actually get a job in […]

2 Linked Table Query Returning Incorrect Results

We had this annoying problem: a simple query in Access to a linked table (using ODBC and MS SQL server) returned incorrect results, though the same query returned correct results in MS SQL server. By incorrect I mean the field values were different, so rather than returning AZ, the query returned BZ (some other value […]

0 Microsoft query in Excel and Case statement

It is frustrating that I need to pull the data from SQL server using complex queries and then format it in Excel to ”prettify” the data. Thankfully, I can use the Microsoft query in Excel to get the data from SQL server and create a table or a PivotTable. Today, I encountered a problem with […]

1 Mining publication data

I found treasure! Publication and citation data with metadata (author names, addresses, affiliation): http://citeseer.ist.psu.edu/oai.html I was reading about knowledge management here, which says that knowledge management is nonsense. I agree to a certain degree, not because of the field, but because of its name. How do you manage knowledge? Isn’t knowledge derived? Wasn’t information “science” […]

« Previous 1 … 11 12 13 14 15 … 27 Next »