I saw one of my classmates do quick normal distribution by the click of a button and when I asked her she said she used VBA function of Excel.
This is what I would like to do: Have a macro/VBA in one excel file. And using that excel file do normal distribution for an excel file that's opened in another window.
I know EXCEL has functions for both the NORMAL DISTRIBUTION and the
cumulative value thereof...
but is it possible to graph this data..
(I imagine if I sort the data and then calculate the ***. distributions into
a column...then chart it, it should work; BUT IS THERE ANOTHER WAY?)
Say I measure the height of 1000 people and I have those in a column in excel. It should be a normal distribution with mean x and standard deviation y. How do I actually graph it so I can see the normal distrubution curve that looks something like this:
[url]
I tried making a scatter graph but it graphs them point by point. I want the height to be on the x axis and something like frequency on the y axis.
i have some number that i want to put in a normal distribution
so.. i have age ( 1, 2, 3, 4, 5, 6, 7, 8, 9, 10) and have the number of times that the kid wake in the night ( 10, 12, 9,11,8,9,7,9,11) and want to do the normal distribution grafic with that .
How to crate a chart for normal distribution for a set of datas. say marks of students/ number of students in a class
View 1 Replies View RelatedI'm trying to make a bell curve (normal gauss distribution). I have some problems regarding the probability density curve, since its values are so low. If you look column N in the attached file - I used the NORMDIST command. Values should be somewhere between 0,2 and 0,4 - but they're about 100x lower.
View 2 Replies View Relatedin VBA the RND function generates a random number using uniform distribution (every number is as likely as any other). Is there a function to generate a random number using normal distribution where the numbers closest to the mean are more likely to occure then numbers further away from the mean. I've created the following custom function to generate a random number between two given values using uniform distribution.
Function RandNum(Min As Double, Max As Double) As Double
RandNum = (Max - Min) * Rnd + Min
End Function
I would like to create a random number based on that data.
View 3 Replies View RelatedI would like to generate a random value using a skewed normal distribution. For inputs I have the sample mean, standard deviation, and skewness. I would like to find a way to generate numbers randomly that would fit the skewed normal distribution described by the inputs.
Some information about skewed normal distributions can be found here: ...
I have weird alpha value like 14.385%, a sample size (36). What is the corresponding critical value for the normal distribution. There are questions like this dealing with the Student T dist, Chi Squared and F distribution. If i can figure out how to do it for one I can probably do it for all of them.
I would like to get random number generator for normal distribution and I’m using:
=NORMINV(RAND(),$B$1,$B$2)
Where B1 is mean (average) and B2 is SD.
This command works, but in the random generating numbers, I’m getting positive and negative numbers (ex. -23,34).
how to change command so I can generate positive only numbers?
I need a VB code to open excel files located in a path (fixed path) by providing a part of file name through a input box
for ex: I have some files located in my local drive as below
1. colurgreen.xls
2. colurred.xls
3. colurblue.xls
I need a input box asking for file name and I input "green" or "red" or"blue" and it should open the resp file.
I need to open an excel file based on a date mentioned in the file name, but minus 1 day. The file name is composed with Statistics_date_time.xls
Example: statistics_20140423_142754.xls
Once I need to open the file (only in the mornings), it has to be the one from the previous day to see the yesterdays performance. How can I create a macro that will look at the date in the file and take the one from yesterday?
This will be a part of a macro I'm making. The rest of the macro will just format the file and combine a few ones from different departments.
I have some daily text files in a folder (so about 30 of them each month), which in the end of month, I need to open them up in excel, format them so that I can use the information for my analysis.
I would like to create a macro, to quickly open them all up at once and save them each individually in .xls or .xlsm format.
I am new to VBA and after some research online, I was able to have the files open with the following code. but now I don't know how to proceed further to save them one by one with the same name but in .xls or .xlsm format.
Sub Opentxtfiles()
Dim MyFolder As String
Dim myfile As String
[Code].....
When I prepare a file with macro's (to be used by other people), I save this file as a template with macro's with the extension *.xltm (template with macro).
Therefore no one can overwrite my file. These other people can open this template (e.g. double-click, but not file-open). But when these people save this file, Excel automatically saves it as a normal Excel-file with the extension *.xlsx.
Ok, a message is seen after pressing <enter> or clicking Save, but does normal users know, what they have to do then?
If I'm making a template with macro's, I want Excel to have this file saved as a file with macro's. Whatever did I make a file with macro's for? Is this a bug or is it done on purpose?
I have a folder that contains many excel files. Each excel file is named as that date it was created, i.e. 02/18/09.xls
I would like to have some vba code that will open 'todays' file. Here is what I have so far:
An Excel file with the date founction in A1, =today(). I'd like to have a button that reads cell a1 and opens an excel file in a specific folder.
do a code to open a closed .txt file. Once opened, the data inside of it should be copied on the macro workbook sheet 2 column F. I want the macro to perform a loop until all the .txt files have been opened and copied on the specified sheet and column. No worries I will still include some codes in between .txt files so no overwrite will happen. By the way I want to open the .txt file in sequence base on the file name listed in sheet1 column B2 onwards.
see below list
File Name
1.txt
2.txt
3.txt
4.txt
5.txt
6.txt
7.txt
8.txt
9.txt
10.txt
11.txt
12.txt
So the first .txt file to be open is 1.txt followed by 2.txt and so on it will loop until all filenames have been opened and copied. Path of the file will be in C:SAMPLE
I have a excel file that opens and will automatically run a bunch of tasks if a certain user opens it. This user is only used to automatically run this excel file, other users need to open the file occasionally to edit emails address, add clients etc stuff like that, that the automation part of it works off.
Currently I have this user running the file every hour using Win7 Task Scheduler. This is working well, except for the time when another user is editing the file on the hour and of course the Automated user gets the "this file is open blah blah blah, open as read only, cancel etc" popup, this stalls everything, and if I dont notice it, it could sit like this for days.
The file runs in Read Only fine, so... Basically my question is, how to open this file as "Read Only" using Task Scheduler? As if it just ran as Read Only all the time then it wouldnt matter what other users were editing at any given time.
One of my ideas was to have Task Scheduler run a VBS script instead of running the Excel file directly, and having the VBS script simply load the Excel as Read Only.
I was able to open and read this file before installing Windows 8.
The background to this is that after installing Windows 8 and reinstalling Windows University 2010 my word documents and excel files where all opening up as word pad documents. I figured out the solution to the above on my own and I am now able to properly read the excel and word documents that I tested. But I am not able to read a very important excel file. It is very important that I restore somehow this file.
When I open the excel file a dialogue box open up saying "Excel found unreadable content in "Account.xlsx". Do you want to recover the content of this workbook? When I choose Yes the following dialogue box opens up saying "Excel cannot open the file "Account.xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the extension matches the format of the file".
The file extension is set to xlsx however how do I test to see if it is corrupt. Is there anything I can do to restore this excel workbook?
While opening one Excel file I get an error message saying that a 2nd file could not be opened because it cannot be found. I do not want this 2nd file to open. WHere do I find the "command" that is telling this 2nd file to open.
View 3 Replies View RelatedI seem not to be able to solve, regarding an Excel VB6 integration.
I wish to check if a specific Excel file is open at any given time (I'm using a timer for this.)
This is what I had so far, but I need it to be checking prior to this and I don't like this solution really (wasn't complete.)
Code:
Private Sub Command1_Click()
Dim oXLApp As Excel.Application
Dim oXLBook As Excel.Workbook
[Code]....
I have a file that became too big due to phantom bloat, unused range saved by Excel and all that kind of reasons. Thank to previous posts on that board tackling that issue, I was able to find how to proceed to reduce the file back to its normal size.
But I did so in a beta file (test file). The real file has become so big (103MB!) that Excel cannot even open it anymore! The file contains archive info that we do not have anywhere else.
Is there anyway then to open the file or to reduce its size without opening it (through magics...)? I just honestly don't know how to retrieve that info before deleting that file.
I work for a company that has about 650 locations. Each location has a location manager that is responsible for submitting a Performance Review spreadsheet for all the employees at their location.
Currently I have an Excel file that has all employees/locations. One of the columns on my spreadsheet is "Location ID"...which is literately a number we've assigned to our Locations. I have an Excel template saved that I'd like each Location to open into.
Can someone help me? I need each location to be it's own spreadesheet...which I have a template created already. I'd prefer to find an automated way to do this...rather than manually creating 650 spreadsheets.
I'd prefer to do this in anoter application, such as MS Access, but senior management already made the decision this will be done in Excel...so I'm stuck with what I got.
Is there a way to Open or Import a PDF file in Excel 07 ?
View 2 Replies View RelatedI received a USB drive from a client with an Excel spreadsheet with hyperlinks to PDF's (not sure of the version it was originally created in but my version is 2007). The PDF's are in another folder on the USB drive.
The cells with the hyperlinks have a formula to hidden cells [i.e. =HYPERLINK(C17,B17)] - in column B is the name of the hyperlink and in column C looks to be the file trial to the PDF (please see attached picture).
When I select the link, I get an Alert Box stating, "Cannot open the specified file." How I can get these links to work?
Excel Hyperlinks.png
I have excel file having macros and many formating , I have protected with password but in my office there is only 3 pcs having MS office installed out of 18 pc, all other pc have installed open office. formula and macro is not supporting in open office and also Macro which i have procted in excel easy viewing in open office without asking password (which i don't want )
I want to restrict the file to open in pc where open office installed.
In short excel file should not open other that pc where MS office is not installed.
I have created several excel files as I cannot open them all at once since they are too large. So I have to open one excel file whilst closing another.
part1
part2
part3
part4
part5
I want a macro that opens the excel file part 1 and part 2. Then it should close part 1 and after closing part 1 it should open part 3. Once part 3 is open, part 2 should be closed and when part 2 is closed part 4 should open. When part 4 is open, then part 3 should be closed and part 5 should open.
I have emails come in daily to my outlook 2010 as an excel attachment, is there a way to open these attachement in excel by running a macro?
View 4 Replies View RelatedI have a Listbox which brings up a list of files in 2 folders. The code works perfectly and I have no problems with it however I would like to add a further bit of functionality to the ListBox using:
View 12 Replies View RelatedI am just wondering if there is a way of checking if the workbook that is currently open is the only one that is open, as I have been asked to make my code exit the application if this is the case rather that just close that one file.
View 6 Replies View Related